Re: [HACKERS] Runtime Partition Pruning

David Rowley <david.rowley@2ndquadrant.com>

From: David Rowley <david.rowley@2ndquadrant.com>

To: Jesper Pedersen <jesper.pedersen@redhat.com>

Cc: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>, Beena Emerson <memissemerson@gmail.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>, Robert Haas <robertmhaas@gmail.com>, amul sul <sulamul@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>, Dilip Kumar <dilipbalaut@gmail.com>

Date: 2018-04-05T12:46:01Z

Lists: pgsql-hackers

Attachments

v20-0001-Provide-infrastructure-to-allow-partition-prunin.patch (application/octet-stream) patch v20-0001
v20-0002-Add-bms_prev_member-function.patch (application/octet-stream) patch v20-0002
v20-0003-Allow-Append-subnodes-to-be-pruned-during-execut.patch (application/octet-stream) patch v20-0003
v20-0004-Allow-MergeAppend-s-subnodes-to-be-pruned-during.patch (application/octet-stream) patch v20-0004
v20-0005-Improve-planning-speed-of-partitioned-table-UPDA.patch (application/octet-stream) patch v20-0005

On 5 April 2018 at 14:01, David Rowley <david.rowley@2ndquadrant.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

Commits

Initialize ExprStates once in run-time partition pruning
- 1957f8dabf8d 11.0 landed
Add bms_prev_member function
- 5c0675215e15 11.0 landed
Support partition pruning at execution time
- 499be013de65 11.0 landed
Document partprune.c a little better
- 971d7ddbe19a 11.0 landed
Fix crash in pg_replication_slot_advance
- 6f1d723b6359 11.0 cited
Add parallel-aware hash joins.
- 1804284042e6 11.0 cited
Fix typo.
- 487a0c1518af 11.0 cited
Allow --with-bonjour to work with non-macOS implementations of Bonjour.
- 9b9cb3c4534d 11.0 cited
Mention need for --no-inc-recursive in rsync command
- 2c74e6c1dcc5 11.0 cited