Re: Table partition with primary key in 11.3 - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: Table partition with primary key in 11.3
Date
Msg-id CAH2-Wzno=Wt9-3aH4_A4HazAB48G+8nZ8MNH-HEL8h3wctOcQw@mail.gmail.com
Whole thread Raw
In response to Re: Table partition with primary key in 11.3  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Table partition with primary key in 11.3
List pgsql-general
On Fri, Jun 7, 2019 at 9:10 AM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> I think vacuuming for global indexes is somewhat challenging as well :-)
> Maybe not as much as for indirect indexes, that's true.
>
> In order for it to be sustainable, I think you'll want to reuse
> partition identifiers when the partitions are dropped/detached, which
> means that you need a way to ensure that index entries to those
> partitions are removed from all indexes.

I'm not so sure about that. I see your point, but I think that you can
also make the opposite argument. That is, you can make a good case for
asynchronously cleaning up the dead entries that point to a dropped
partition (probably within VACUUM). Perhaps we should offer *both* as
options.

--
Peter Geoghegan



pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Table partition with primary key in 11.3
Next
From: Alvaro Herrera
Date:
Subject: Re: Table partition with primary key in 11.3