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?
- Slow planning, fast execution for particular 3-table query David Wheeler
- Re: Slow planning, fast execution for particular 3-tabl... Laurenz Albe
- Re: Slow planning, fast execution for particular 3-... David Wheeler
- Re: Slow planning, fast execution for particula... Laurenz Albe
- Re: Slow planning, fast execution for particular 3-tabl... Tom Lane
- Re: Slow planning, fast execution for particular 3-... David Wheeler
- Re: Slow planning, fast execution for particula... Pavel Stehule
- Re: Slow planning, fast execution for parti... David Wheeler
- Re: Slow planning, fast execution for ... Michael Lewis
- Re: Slow planning, fast execution ... David Wheeler
- Re: Slow planning, fast execution for particular 3-tabl... Justin Pryzby
- Re: Slow planning, fast execution for particular 3-... David Rowley
- Re: Slow planning, fast execution for particula... Justin Pryzby