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

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
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 13:37:02
Message-ID: f3ee327a-8c94-eff3-3752-4586117e5210@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

In response to

Responses

Browse pgsql-performance by date

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