3 ms·

Any posts on this? Are there bulk data loads that make table stats more stale and affect plans? I’m wondering what would suddenly make a plan selection change a

• natmaka 3y ago
  > bulk data loads that make table stats more stale This is the usual culprit (cure: "ANALYZE ((tablename))"). Collecting more samples (ALTER TABLE SET STATISTICS...) may be useful. "Extended Statistics" covers most(?) other cases: https://www.postgresql.org/docs/current/planner-stats.html#PLANNER-STATS-EXTENDED https://www.postgresql.org/docs/current/planner-stats.html#P... https://www.postgresql.org/docs/current/multivariate-statistics-examples.html https://www.postgresql.org/docs/current/multivariate-statist...