| 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 |
| 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 |