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.
