Postgres Pro
Downloads
Home   >   mailing lists

Re: Query with high planning time at version 11.1 compared versions10.5 and 11.0 - Mailing list pgsql-performance

From David Rowley
Subject Re: Query with high planning time at version 11.1 compared versions10.5 and 11.0
Date
Msg-id CAKJS1f8cZUzzGQnYKSfzeEe-fscQc9s5wPy4ZNPn-Uq=pDcODw@mail.gmail.com
Whole thread Raw
In response to Query with high planning time at version 11.1 compared versions 10.5and 11.0  (Sanyo Moura <sanyo.moura@tatic.net>)
Responses Re: Query with high planning time at version 11.1 compared versions10.5 and 11.0  (Justin Pryzby <pryzby@telsasoft.com>)
Re: Query with high planning time at version 11.1 compared versions10.5 and 11.0  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-performance
Tree view 
On Wed, 28 Nov 2018 at 03:16, Sanyo Moura <sanyo.moura@tatic.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

pgsql-performance by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Query with high planning time at version 11.1 compared versions10.5 and 11.0
Next
From: Justin Pryzby
Date:
Subject: Re: Query with high planning time at version 11.1 compared versions10.5 and 11.0