From: | Sanyo Moura <sanyo(dot)moura(at)tatic(dot)net> |
---|---|
To: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 |
Date: | 2018-11-27 15:11:49 |
Message-ID: | CAO698qZDi8ycdTKnXAEOPV+e+YA60YPUM7-ETX68q23Rzzv9Fg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
Hello Tom,
Both versions 10.5 and 11.1 are running on the same test server.
What I did was migrate the database from 10.5 to 11.1 via pg_upgrade. After
successful execution, I performed "vacuumdb --all --analyze-in-stages".
Thanks,
Sanyo Capobiango
Em ter, 27 de nov de 2018 às 13:00, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> escreveu:
> Sanyo Moura <sanyo(dot)moura(at)tatic(dot)net> writes:
> > And below are the times generated by EXPLAIN ANALYZE:
>
> > 10.5
> > Planning time: 126.080 ms
> > Execution time: 2.306 ms
>
> > 11.0
> > Planning Time: 7.238 ms
> > Planning Time: 2.638 ms
>
> > 11.5 (I assume you mean 11.1 here)
> > Planning Time: 15138.533 ms
> > Execution Time: 2.310 ms
>
> There were no changes between 11.0 and 11.1 that look like they'd affect
> planning time. Nor does it seem particularly credible that planning time
> would have dropped by a factor of 15 between 10.x and 11.x, especially
> not given that the resulting plan didn't change. I think you've got some
> external factor causing long planning times --- maybe something taking an
> exclusive lock on one of the tables, or on pg_statistic?
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Karlsson | 2018-11-27 15:23:50 | Re: Remove Deprecated Exclusive Backup Mode |
Previous Message | Stephen Frost | 2018-11-27 15:11:43 | Re: Remove Deprecated Exclusive Backup Mode |
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2018-11-27 19:34:53 | Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 |
Previous Message | Tom Lane | 2018-11-27 15:00:08 | Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 |