Any posts on this? Are there bulk data loads that make table stats more stale an... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

jhas78asd on May 12, 2023 | parent | context | favorite | on: Ask HN: It's 2023, how do you choose between MySQL...

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 lot that might be a contributing factor.

natmaka on May 13, 2023 [–]

> 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#P... https://www.postgresql.org/docs/current/multivariate-statist...

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact