| From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Configuration knobs & dials to speed up query optimization |
| Date: | 2023-11-23 14:28:46 |
| Message-ID: | 1e919e06-9014-0a03-3947-06fc405e4f78@a-kretschmer.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Torsten Förtsch | 2023-11-23 15:34:13 | Re: Corruption or wrong results with 14.10? |
| Previous Message | Ron Johnson | 2023-11-23 14:20:00 | Re: Configuration knobs & dials to speed up query optimization |