| From: | Michael Lewis <mlewis(at)entrata(dot)com> |
|---|---|
| To: | Mladen Marinović <mladen(dot)marinovic(at)kset(dot)org> |
| Cc: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Slow planing... |
| Date: | 2019-12-06 15:43:17 |
| Message-ID: | CAHOFxGrE7EAMJBOeSNwOejUu8=gRAF2BbU=yfkx8ifrFwn741Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Dec 6, 2019, 3:21 AM Mladen Marinović <mladen(dot)marinovic(at)kset(dot)org>
wrote:
> Is there a way to detect why the planing is taking this long?
>
> The database is a 9.6.1 with 32GB of shared_buffers, and 1GB of
> maintanance_work_mem, and machine CPU is below 80% all the time.
>
What is default_statistics_target set to for your cluster or the involved
tables/columns? When raised above the default 100, planning time can
increase exponentially it seems, as the planner examines the stats and
weighs the many options.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Julie Nishimura | 2019-12-06 16:14:45 | Re: upgrade and migrate |
| Previous Message | Adrian Klaver | 2019-12-06 15:38:58 | Re: Insert Table from Execute String Query |