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
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
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
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