>
> *autovacuum_analyze_threshold*
> *autovacuum_analyze_scale_factor*
>
Changing these will impact how often the table is analyzed based on the
rough count of changed rows. You may want to adjust autovacuum settings as
well so that dead space can be reused.
> *default_statistics_target*
>
Increa
Hi
We have a busy postgres 10 Db with a principal table that holds about 15
million active rows and has about 90M Inserts|Updates|Deletes a day.
All performs well, except a small number of monitoring SQL statements of the
nature
select code, max(timestamp) from mainTable group by code;
After
