Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0

David Rowley <david.rowley@2ndquadrant.com>

From: David Rowley <david.rowley@2ndquadrant.com>

To: sanyo.moura@tatic.net

Cc: pgsql-performance@lists.postgresql.org

Date: 2018-11-28T04:03:15Z

Lists: pgsql-hackers, pgsql-performance

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

Commits

Postpone generating tlists and EC members for inheritance dummy children.
- b10e3bba8673 11.2 landed
- 8d8dcead1295 12.0 landed
Allow direct lookups of AppendRelInfo by child relid
- 7d872c91a3f9 11.0 cited