Re: speeding up planning with partitions

From: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
To: Amit Langote <amitlangote09(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: "Imai, Yoshikazu" <imai(dot)yoshikazu(at)jp(dot)fujitsu(dot)com>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: speeding up planning with partitions
Date: 2019-01-10 08:41:21
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 2019/01/10 0:16, Amit Langote wrote:
> On Wed, Jan 9, 2019 at 11:41 PM Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote:
>>> From 3b86331dd5a2368adc39c9fef92f3dd09d817a08 Mon Sep 17 00:00:00 2001
>>> From: amit <amitlangote09(at)gmail(dot)com>
>>> Date: Wed, 7 Nov 2018 16:51:31 +0900
>>> Subject: [PATCH v11 4/6] Move inheritance expansion code into its own file
>> I wonder if it would make sense to commit 0004 ahead of the rest? To
>> avoid carrying this huge one over and over ...
> Maybe a good idea. I will rearrange the patches that way tomorrow.

Here's v12, which is more or less same as v11 but with the order of
patches switched so that the code movement patch is first. Note that the
attached v12-0001 contains no functional changes (but there's tiny note in
the commit message mentioning the addition of a tiny function which is
just old code).

In the v13 that I will try to post tomorrow, I will have hopefully
addressed David's and Imai-san's review comments. Thank you both!


Attachment Content-Type Size
v12-0001-Move-inheritance-expansion-code-into-its-own-fil.patch text/plain 88.3 KB
v12-0002-Overhaul-inheritance-update-delete-planning.patch text/plain 71.2 KB
v12-0003-Store-inheritance-root-parent-index-in-otherrel-.patch text/plain 2.5 KB
v12-0004-Lazy-creation-of-RTEs-for-inheritance-children.patch text/plain 91.3 KB
v12-0005-Teach-planner-to-only-process-unpruned-partition.patch text/plain 6.9 KB
v12-0006-Do-not-lock-all-partitions-at-the-beginning.patch text/plain 1.8 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Arkhena 2019-01-10 08:46:08 Re: [Sender Address Forgery]Re: error message when subscription target is a partitioned table
Previous Message Amit Langote 2019-01-10 08:26:16 Re: [Sender Address Forgery]Re: error message when subscription target is a partitioned table