Horton

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

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Justin Pryzby <pryzby@telsasoft.com>, Sanyo Moura <sanyo.moura@tatic.net>, jeff.janes@gmail.com, David Rowley <david.rowley@2ndquadrant.com>, Robert Haas <robertmhaas@gmail.com>, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, pgsql-performance@lists.postgresql.org, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2018-12-06T07:55:40Z
Lists: pgsql-hackers, pgsql-performance 
On 2018-Dec-06, Amit Langote wrote:

Hi

> [ Parallel SeqScan on precio_126 to precio_998  ]
> 
> >                      ->  Parallel Seq Scan on precio_999 p_874  (cost=0.00..27.50 rows=1 width=16)
> >                            Filter: ((fecha >= '1990-05-06 00:00:00'::timestamp without time zone) AND (fecha <= '1999-05-07 00:00:00'::timestamp without time zone) AND (pluid = 2))
> 
> As you can see from the "Filter: " property above, the baserestrictinfo of
> this Append's parent relation is:
> 
> BETWEEN '1990-05-06' AND '1999-05-07'
> 
> which selects partitions for all days from '1990-05-06' (precio_125) up to
> '1992-09-26' (precio_999).

Looking at my .psql_history, you're right -- I typoed 1990 as 1999 in
one of the clauses.  Thanks, mystery solved :-)

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Postpone generating tlists and EC members for inheritance dummy children.

  2. Allow direct lookups of AppendRelInfo by child relid