Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas Kretschmer
Subject Re: Slow planning time when public schema included (12 vs. 9.4)
Date
Msg-id f3ee327a-8c94-eff3-3752-4586117e5210@a-kretschmer.de
Whole thread Raw
In response to Slow planning time when public schema included (12 vs. 9.4)  (Anders Steinlein <anders@e5r.no>)
Responses Re: Slow planning time when public schema included (12 vs. 9.4)  (Anders Steinlein <anders@e5r.no>)
List pgsql-performance
Tree view 

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

pgsql-performance by date:

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