Am 22.11.23 um 17:13 schrieb Ron Johnson:
> Pg 9.6.24, which will change by April, but not now.
>
>
out of support since many years!
>
> Here are the only non-default config values which I can think of that
> are relevant to the question at hand:
> shared_buffers = 16GB
> work_mem = 300MB
> maintenance_work_mem = 12GB
> effective_cache_size = 96GB
> default_statistics_target = 200
As Laurenz said, default_statistics_target is too high at 200 in my
opinion. It makes all planning more expensive and increases internal
statistics. It is better to do this specifically for selected
tables/columns.
Andreas
--
Andreas Kretschmer - currently still (garden leave)
Technical Account Manager (TAM)
www.enterprisedb.com