Step 6: Improving Query Efficiency After Data Import

After data is imported, run the ANALYZE statement to generate table statistics. The statistics data is useful when you run the planner, which provides you with an efficient query execution plan.

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.

Run VACUUM FULL on the product_info table.

     
          openGauss=# VACUUM FULL product_info;

VACUUM

Update statistics in the product_info table.

     
          openGauss=# ANALYZE product_info;

ANALYZE

Parent topic: Tutorial: Using GDS to Import Data from a Remote Server

Previous topic: Step 5: Analyzing and Handling Import Errors

Next topic: Step 7: Stopping GDS

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot