Re: [HACKERS] path toward faster partition pruning

From: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
To: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Beena Emerson <memissemerson(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] path toward faster partition pruning
Date: 2018-03-20 11:07:06
Message-ID: 8518d31e-8f31-c643-1cbb-0a855d50fb32@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2018/03/16 21:55, Amit Langote wrote:
> Attached updated patches.

Attached is further revised version.

Of note is getting rid of PartitionPruneContext usage in the static
functions of partprune.c. Most of the code there ought to only run during
planning, so it can access the necessary information from RelOptInfo
directly instead of copying it to PartitionPruneContext and then passing
it around.

Thanks,
Amit

Attachment Content-Type Size
v38-0001-Add-partsupfunc-to-PartitionSchemeData.patch text/plain 3.4 KB
v38-0002-Add-more-tests-for-partition-pruning.patch text/plain 16.3 KB
v38-0003-Faster-partition-pruning.patch text/plain 100.2 KB
v38-0004-Add-only-unpruned-partitioned-child-rels-to-part.patch text/plain 24.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Antonin Houska 2018-03-20 11:11:17 Define variable only in the scope that needs it
Previous Message Amit Kapila 2018-03-20 11:02:31 Re: XID-assigned idle transactions affect vacuum's job.