Re: [HACKERS] Proposal: Local indexes for partitioned table

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Maksim Milyutin <milyutinma(at)gmail(dot)com>
Subject: Re: [HACKERS] Proposal: Local indexes for partitioned table
Date: 2017-12-20 19:49:37
Message-ID: 20171220194937.pldcecyx7yrwmgkg@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Just to show what I'm talking about, here are a few prototype patches.
Beware, these are all very lightly tested/reviewed. Input is welcome,
particularly if it comes in the guise of patches to regression tests
showing cases that misbehave.

0001 is a fixup for the v6 patch I posted upthread; it's needed so the
0002 patch doesn't end up with indexes marked invalid after pg_dump.

Álvaro Herrera
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment Content-Type Size
v7-0001-Fixup-Local-partitioned-indexes-v6.patch text/plain 942 bytes
v7-0002-allow-indexes-on-partitioned-tables-to-be-unique.patch text/plain 21.6 KB
v7-0003-Allow-FOR-EACH-ROW-triggers-on-partitioned-tables.patch text/plain 15.0 KB
v7-0004-WIP-Allow-foreign-key-triggers-on-partitioned-tab.patch text/plain 29.2 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2017-12-20 20:07:58 Re: Missed parallelism option in plpgsql?
Previous Message neto brpr 2017-12-20 19:49:23 Re: Cost Model