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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Slow planning time when public schema included (12 vs. 9.4)
From: Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx>
Date: Sat, 21 Mar 2020 14:37:02 +0100
In-reply-to: <CAC35HN=tS6zDy0FcQ-mPjsZ9eO_37fe9m3mLDQ+zWZWrqEB9rw@mail.gmail.com>
References: <CAC35HN=tS6zDy0FcQ-mPjsZ9eO_37fe9m3mLDQ+zWZWrqEB9rw@mail.gmail.com>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.4.1



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 particulartables and columns.


Regards, Andreas

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

Follow-Ups:
- Re: Slow planning time when public schema included (12 vs. 9.4)
  - From: Anders Steinlein

References:
- Slow planning time when public schema included (12 vs. 9.4)
  - From: Anders Steinlein

Prev by Date: Slow planning time when public schema included (12 vs. 9.4)
Next by Date: Re: Slow planning time when public schema included (12 vs. 9.4)
Previous by thread: Slow planning time when public schema included (12 vs. 9.4)
Next by thread: Re: Slow planning time when public schema included (12 vs. 9.4)
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux