Re: Configuration knobs & dials to speed up query optimization

2023-11-23 Thread Andreas Kretschmer
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 maintenanc

Re: Configuration knobs & dials to speed up query optimization

2023-11-23 Thread Ron Johnson
On Thu, Nov 23, 2023 at 3:48 AM Laurenz Albe wrote: > On Wed, 2023-11-22 at 11:13 -0500, Ron Johnson wrote: > > Pg 9.6.24, which will change by April, but not now. > > > > We've got some huge (2200 line long) queries that are many UNIONs > of complicated > > queries hitting inheritance-partitione

Re: Configuration knobs & dials to speed up query optimization

2023-11-23 Thread Laurenz Albe
On Wed, 2023-11-22 at 11:13 -0500, Ron Johnson wrote: > Pg 9.6.24, which will change by April, but not now. > > We've got some huge (2200 line long) queries that are many UNIONs of  > complicated > queries hitting inheritance-partitioned tables.  They can't be refactored > immediately, > and mayb

Configuration knobs & dials to speed up query optimization

2023-11-22 Thread Ron Johnson
Pg 9.6.24, which will change by April, but not now. We've got some huge (2200 line long) queries that are many UNIONs of complicated queries hitting inheritance-partitioned tables. They can't be refactored immediately, and maybe not at all (complicated applications hitting normalized databases ma