Re: speeding up planning with partitions - Mailing list pgsql-hackers

From David Rowley
Subject Re: speeding up planning with partitions
Date
Msg-id CAKJS1f8fmcs2Smsm0K-2ZLZjv2GUs+qFZsaL2FmUi8Hed4dstw@mail.gmail.com
Whole thread Raw
In response to Re: speeding up planning with partitions  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: speeding up planning with partitions  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Re: speeding up planning with partitions  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
On Fri, 4 Jan 2019 at 04:39, Justin Pryzby <pryzby@telsasoft.com> wrote:
> Running 11dev with your v10 patch applied, this takes 2244ms with empty buffer
> cache after postmaster restarted on a totally untuned instance (and a new
> backend, with no cached opened files).
>
> I was curious why it took even 2sec, and why it did so many opens() (but not
> 20k of them that PG11 does):

It would be pretty hard to know that without seeing the query plan.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-hackers by date:

Previous
From: Mitar
Date:
Subject: Re: Implementing Incremental View Maintenance
Next
From: Masahiko Sawada
Date:
Subject: Re: A few new options for vacuumdb