Re: Slow planning, fast execution for particular 3-table query - Mailing list pgsql-performance

From Michael Lewis
Subject Re: Slow planning, fast execution for particular 3-table query
Date
Msg-id CAHOFxGpJSCGjTaHsZ-kJu0JOBhAAR-V1MEFRyi-WTSomvCXaXA@mail.gmail.com
Whole thread Raw
In response to Re: Slow planning, fast execution for particular 3-table query  (David Wheeler <dwheeler@dgitsystems.com>)
Responses Re: Slow planning, fast execution for particular 3-table query  (David Wheeler <dwheeler@dgitsystems.com>)
List pgsql-performance
Is default_statistics_target set above default 100? I would assume that would reflect in the size of pg_statistic, but wanted to ask since increasing that from 100 to 1000 was the only time I have seen planning time explode. Are other queries slow to plan?

pgsql-performance by date:

Previous
From: David Wheeler
Date:
Subject: Re: Slow planning, fast execution for particular 3-table query
Next
From: Justin Pryzby
Date:
Subject: Re: Slow planning, fast execution for particular 3-table query