Postgres Pro
Downloads
Home   >   mailing lists

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

From David Rowley
Subject Re: Table partition with primary key in 11.3
Date
Msg-id CAKJS1f_cRNf=5Av5fxNYzYir7zR2yzU5Ws6zC6kz1coKx4mE6A@mail.gmail.com
Whole thread Raw
In response to Re: Table partition with primary key in 11.3  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Table partition with primary key in 11.3
List pgsql-general
Tree view 
On Fri, 7 Jun 2019 at 08:48, Peter Geoghegan <pg@bowt.ie> wrote:
> Andres has
> suggested that I work on variable-width table identifiers in nbtree
> for the benefit of pluggable storage engines, but I don't have much
> enthusiasm for the idea of doing that without delivering a clear
> benefit to users in the same release.

You may already be aware, but another use case for such variable-width
identifiers was with indirect indexes as discussed in [1]

[1] https://www.postgresql.org/message-id/20161018182843.xczrxsa2yd47pnru%40alvherre.pgsql

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Table partition with primary key in 11.3
Next
From: Adrian Klaver
Date:
Subject: Re: postgres 11 issue?