Postgres Pro
Downloads
Home   >   mailing lists

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-WzkP9wD=fYUQh+SGh+kFJc9AngsjfiUegQKvd4ZyYWk8JQ@mail.gmail.com
Whole thread Raw
In response to Re: Table partition with primary key in 11.3  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: Table partition with primary key in 11.3
List pgsql-general
Tree view 
On Thu, Jun 6, 2019 at 3:00 PM David Rowley
<david.rowley@2ndquadrant.com> wrote:
> You may already be aware, but another use case for such variable-width
> identifiers was with indirect indexes as discussed in [1]

Right. I went with global indexes because indirect indexes are
probably a lot more risky as a project. I'd be particularly concerned
about the complexity of VACUUM there, whereas that doesn't seem all
that bad in the case of global indexes.

-- 
Peter Geoghegan

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump include/exclude data, was: verify checksums / CREATE DATABASE
Next
From: Alvaro Herrera
Date:
Subject: Re: Table partition with primary key in 11.3