Re: Slow planning time when public schema included (12 vs. 9.4)

From: Anders Steinlein <anders(at)e5r(dot)no>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Slow planning time when public schema included (12 vs. 9.4)
Date: 2020-03-21 15:45:47
Message-ID: CAC35HN=DOxkRKq8aPPnxVfcutxOTggZdgmzZ6TdFEJ7gvj6O6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Mar 21, 2020 at 2:37 PM Andreas Kretschmer <andreas(at)a-kretschmer(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Anders Steinlein 2020-03-21 15:59:07 Re: Slow planning time when public schema included (12 vs. 9.4)
Previous Message Tom Lane 2020-03-21 14:26:17 Re: Slow planning time when public schema included (12 vs. 9.4)