Re: 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: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Maksim Milyutin <m(dot)milyutin(at)postgrespro(dot)ru>
Subject: Re: Proposal: Local indexes for partitioned table
Date: 2017-10-23 15:12:51
Message-ID: 20171023151251.j75uoe27gajdjmlm@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


I started with Maksim's submitted code, and developed according to the
ideas discussed in this thread. Attached is a very WIP patch series for
this feature.

Many things remain to be done before this is committable: pg_dump
support needs to be written. ALTER INDEX ATTACH/DETACH not yet
implemented. No REINDEX support yet. Docs not updated (but see the
regression test as a guide for how this is supposed to work; see patch
0005). CREATE INDEX CONCURRENTLY not done yet.

I'm now working on the ability to build unique indexes (and unique
constraints) on top of this.

The docs have not been updated yet, but the new regression test file
illustrates how this works.

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

Attachment Content-Type Size
v1-0001-Tweak-index_create-index_constraint_create-APIs.patch text/plain 15.1 KB
v1-0002-Allow-indexes-on-partitioned-tables.patch text/plain 45.6 KB
v1-0003-export-generateClonedIndexStmt.patch text/plain 3.1 KB
v1-0004-Match-create-indexes-during-ATTACH-PARTITION.patch text/plain 8.3 KB
v1-0005-add-regression-test.patch text/plain 13.6 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Khandekar 2017-10-23 15:15:25 Re: UPDATE of partition key
Previous Message Michael Paquier 2017-10-23 13:50:24 Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much