Case: Adjusting Partial Clustering Keys

Symptom

Information on the EXPLAIN PERFORMANCE at a site is as follows: As shown in the red boxes, two performance bottlenecks are scan operations in a table.

Optimization Analysis

Based on further analysis, the filter condition acct_id = 'A012709548'::bpchar exists in Scan of two tables.

Try to add the partial clustering key in the acct_id column of the two tables, and run the VACUUM FULL statement to make the local clustering take effect. The table performance is improved.