| 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 |
| Thread: | |
| Lists: | pgsql-hackers |
Hello
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 https://www.2ndQuadrant.com/
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 |
| 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 |