Re: [HACKERS] Runtime Partition Pruning

From: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
To: Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>
Cc: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>, Beena Emerson <memissemerson(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, amul sul <sulamul(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>
Subject: Re: [HACKERS] Runtime Partition Pruning
Date: 2018-04-05 12:46:01
Message-ID: CAKJS1f-wRKSYsefyqXUSEeMhGEu9JYHuEAk8Xtoe=u_d_zp5+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 5 April 2018 at 14:01, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> wrote:
> I've attached an updated patchset against Amit's v49 faster partition
> pruning patch.

Well, v19 was short lived. 0005 conflicted with some recent changes to MERGE.

The attached v20 patch set is now based on Amit's runtime partition
prune v50 [1].

There are a few changes since v19:

1. I've run pgindent on the entire patchset.
2. Made a pass over the comments and fixed a few things that were not
quite right. Also improved some wording.
3. Fixed a small error in make_partition_pruneinfo where I had
accidentally used the 'i' variable for two purposes at once. There was
no live bug there, but I've now changed things around as what was
there was wrong regardless of if it was causing issues or not.
4. updated typedefs.list with new typedefs added in the patchset.

[1] https://www.postgresql.org/message-id/77a518ac-e4a0-4cd1-9988-e5d754a6501f%40lab.ntt.co.jp

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

Attachment Content-Type Size
v20-0001-Provide-infrastructure-to-allow-partition-prunin.patch application/octet-stream 43.6 KB
v20-0002-Add-bms_prev_member-function.patch application/octet-stream 5.3 KB
v20-0003-Allow-Append-subnodes-to-be-pruned-during-execut.patch application/octet-stream 87.2 KB
v20-0004-Allow-MergeAppend-s-subnodes-to-be-pruned-during.patch application/octet-stream 18.4 KB
v20-0005-Improve-planning-speed-of-partitioned-table-UPDA.patch application/octet-stream 27.5 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Matheus de Oliveira 2018-04-05 12:47:48 Re: [PATCH] btree_gin, add support for uuid, bool, name, bpchar and anyrange types
Previous Message Michael Banck 2018-04-05 12:41:13 Re: pgsql: Validate page level checksums in base backups