Re: Slow planning, fast execution for particular 3-table query
Michael Lewis <[email protected]> Wed, 6 Nov 2019 15:56:50 -0700
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <CAHOFxGpJSCGjTaHsZ-kJu0JOBhAAR-V1MEFRyi-WTSomvCXaXA@mail.gmail.com> |
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?