| From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
|---|---|
| To: | sanyo(dot)moura(at)tatic(dot)net |
| 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-28 04:03:15 |
| Message-ID: | CAKJS1f8cZUzzGQnYKSfzeEe-fscQc9s5wPy4ZNPn-Uq=pDcODw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
On Wed, 28 Nov 2018 at 03:16, Sanyo Moura <sanyo(dot)moura(at)tatic(dot)net> wrote:
> 11.0
> Planning Time: 7.238 ms
> Planning Time: 2.638 ms
>
> 11.5
> Planning Time: 15138.533 ms
> Execution Time: 2.310 ms
Does it still take that long after running ANALYZE on the partitioned table?
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyotaro HORIGUCHI | 2018-11-28 04:14:28 | Re: Tab completion for ALTER INDEX|TABLE ALTER COLUMN SET STATISTICS |
| Previous Message | rajan | 2018-11-28 03:41:30 | Re: vacuum and autovacuum - is it good to configure the threshold at TABLE LEVEL? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Pryzby | 2018-11-28 04:17:50 | Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 |
| Previous Message | Justin Pryzby | 2018-11-28 03:01:29 | Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 |