RE: Declarative Range Partitioning Postgres 11

From: Shatamjeev Dewan <sdewan(at)nbsps(dot)com>
To: Michael Lewis <mlewis(at)entrata(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: RE: Declarative Range Partitioning Postgres 11
Date: 2019-10-08 13:55:02
Message-ID: F2F23E564EB92A4C80228EB86713BA130BDA7C@TO1RODC.nbspaymentsolutions.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Michael.

From: Michael Lewis <mlewis(at)entrata(dot)com>
Sent: October-07-19 7:18 PM
To: Shatamjeev Dewan <sdewan(at)nbsps(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Arnaud L. 2019-10-08 13:59:14 Re: psql \copy hanging
Previous Message Robert Heinen 2019-10-08 11:57:07 Re: GPS coordinates problem