Re:Working around a case where the Postgres planner is “not ...
by baq on Monday August 02, 2021 @04:14PM
(#28042009)
we're running 'ANALYZE table' with default_statistics_target set in the connection to the max reasonable value for the dataset size every 4 hours to avoid just that. also, the default checklist item for sudden slowness of postgres is a manual ANALYZE with a bumped statistics target.
[ Parent
| on HN ]
There are no comments on this comment yet.