From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Jonathan S. Katz <jkatz@postgresql.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Documentation for partitioned indexes?
Date: Thu, 16 May 2019 16:10:22 -0400
Message-ID: <20190516201022.GA15736@alvherre.pgsql> (raw)
In-Reply-To: <10560.1556306072@sss.pgh.pa.us> <092b21a2-9579-0f1d-bf22-d6b3db2a8b48@postgresql.org>
On 2019-Apr-26, Tom Lane wrote:
> Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> > I suppose I better add something in Chapter 5 (DDL), possibly inside the
> > 5.10 section (Table Partitioning) -- a new 5.10.6 "Indexes for
> > Partitioned Tables" perhaps?
>
> I was expecting to find it in "5.11.2.2. Partition Maintenance".
Here's a first attempt at doing that. I vote to backpatch this to pg11
(since this functionality is all there).
> BTW, is there anything equivalent for unique/pkey constraints?
> I tried "add constraint unique ... not valid" and just got a
> raspberry.
Sure, just "alter table only parent", without explicitly marking it not
valid. Then the indexes on children must be attached to the parent
indexes; this searches for constraints and does the right thing.
On 2019-Apr-26, Jonathan S. Katz wrote:
> I'd suggest keeping the title of the section similar to the one with
> constraints, i.e. "Partitioning and Indexes"
In the end, it seemed material far too short to have its own subsection,
but maybe if we redesign the whole section we could lay it out
differently? (One idea would be to leave 5.11 for declarative
partitioning, and add a new section 5.12 for legacy inheritance.
Something to think about for pg13)
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Attachments:
[text/x-diff] 0001-Describe-creation-of-partitioned-index-piecemeal.patch (0B, ../20190516201022.GA15736@alvherre.pgsql/2-0001-Describe-creation-of-partitioned-index-piecemeal.patch)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: alvherre@2ndquadrant.com, jkatz@postgresql.org, tgl@sss.pgh.pa.us, pgsql-docs@lists.postgresql.org
Subject: Re: Documentation for partitioned indexes?
In-Reply-To: <20190516201022.GA15736@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox