Horton

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

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: David Rowley <david.rowley@2ndquadrant.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, Jesper Pedersen <jesper.pedersen@redhat.com>, Simon Riggs <simon@2ndquadrant.com>, Pg Hackers <pgsql-hackers@postgresql.org>, Maksim Milyutin <milyutinma@gmail.com>, Jaime Casanova <jaime.casanova@2ndquadrant.com>
Date: 2018-01-11T18:52:07Z
Lists: pgsql-hackers

Attachments

The delta patch turned out to have at least one stupid bug, and a few
non-stupid bugs.  Here's an updated version that should behave
correctly, and addresses all reported problems.

(One minor issue Jaime found and I hadn't listed is that alter_index and
alter_table SGML pages said "ATTACH" instead of "ATTACH PARTITION".
Fixed those too for this version.)

I'll set this as Ready for Committer now.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Local partitioned indexes

  2. Fix StoreCatalogInheritance1 to use 32bit inhseqno

  3. Get rid of copy_partition_key

  4. Simplify index_[constraint_]create API