Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow planning time when public schema included (12 vs. 9.4) - Mailing list pgsql-performance

From Anders Steinlein
Subject Re: Slow planning time when public schema included (12 vs. 9.4)
Date
Msg-id CAC35HN=DOxkRKq8aPPnxVfcutxOTggZdgmzZ6TdFEJ7gvj6O6g@mail.gmail.com
Whole thread Raw
In response to Re: Slow planning time when public schema included (12 vs. 9.4)  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-performance
Tree view
On Sat, Mar 21, 2020 at 2:37 PM Andreas Kretschmer <andreas@a-kretschmer.de> wrote:


Am 21.03.20 um 13:02 schrieb Anders Steinlein:
> default_statistics_target = 1000

not sure if this be the culprit here, but i think this is way too high.
Leave it at the normal value of 100 and raise it only for particular
tables and columns.

It may very well be too high, but the 9.4 instance also has default_statistics_target = 1000.

Best,
-- a.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow planning time when public schema included (12 vs. 9.4)
Next
From: Anders Steinlein
Date:
Subject: Re: Slow planning time when public schema included (12 vs. 9.4)