RE: Declarative Range Partitioning Postgres 11

[Shatamjeev Dewan <sdewan@xxxxxxxxx>]

Thanks Michael.

 

From: Michael Lewis <mlewis@xxxxxxxxxxx>
Sent: October-07-19 7:18 PM
To: Shatamjeev Dewan <sdewan@xxxxxxxxx>
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
Subject: Re: Declarative Range Partitioning Postgres 11

 

No, what you want is not possible and probably won't ever be I would expect. Scanning every partition to validate the primary key isn't scalable.