Help Center > > Developer Guide> Data Import> Doing VACUUM to a Table

Doing VACUUM to a Table

Updated at: Mar 13, 2020 GMT+08:00

If a large number of rows were updated or deleted during import, run VACUUM FULL before ANALYZE. A large number of updates and delete operations generate huge disk page fragments, which reduces the query efficiency. VACUUM FULL can restore disk page fragments and return them to the OS.

  1. Run the VACUUM FULL statement.

    Do VACUUM FULL to the product_info table:
    1
    VACUUM FULL product_info
    
    VACUUM

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel