Re: Declarative Range Partitioning Postgres 11 - Mailing list pgsql-general

From Ron
Subject Re: Declarative Range Partitioning Postgres 11
Date
Msg-id 28854683-c0d9-1e33-7ae1-ddf51c58148a@gmail.com
Whole thread Raw
In response to Re: Declarative Range Partitioning Postgres 11  (Michael Lewis <mlewis@entrata.com>)
Responses Re: Declarative Range Partitioning Postgres 11
List pgsql-general
On 10/7/19 6:17 PM, Michael Lewis wrote:
> No, what you want is not possible and probably won't ever be I would expect.

Sure it is.  Maybe not the (weird) way that Postgres does partitioning, but 
the legacy RDBMS that I still occasionally maintain has for at least 25 
years had partition key independent of any indexes.

> Scanning every partition to validate the primary key isn't scalable.

That's only because of the way Pg implements partitioning.

-- 
Angular momentum makes the world go 'round.



pgsql-general by date:

Previous
From: Michael Lewis
Date:
Subject: Re: Declarative Range Partitioning Postgres 11
Next
From: Pankaj Jangid
Date:
Subject: Re: PG 12 not yet for mac