Analyzing effect on default_statistics_target on ANALYZE
Last week, I received request to increase PostgreSQL’s config parameter default_statistics_target on one of the very large DB clusters. The developers filled a ticket to increase the default_statistics_target to 10,000 at cluster level because one of the queries has started full sequencial scan instead of index scan. By default, Postges cluster sets default_statistics_target to 100 but you can set up to […]