| From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)2ndquadrant(dot)com>, Hannu Krosing <hannu(at)2ndQuadrant(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Greg Stark <stark(at)mit(dot)edu>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: On partitioning |
| Date: | 2014-09-02 04:52:03 |
| Message-ID: | 54054CF3.4040205@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 09/01/2014 11:52 PM, Andres Freund wrote:
> I personally think that implementing cross partition indexes has a low
> enough cost/benefit ratio that I doubt it's wise to tackle it anytime
> soon.
UNIQUE constraints on partitioned tables (and thus foreign key
constraints pointing to partitioned tables) are a pretty big limitation
at the moment.
That said, the planner may well be able to use the greater knowledge of
the partitioned table structure to do this implictly, as it knows that a
unique index on the partition is also implicitly unique across
partitions on the partitioning key.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2014-09-02 04:58:55 | Re: On partitioning |
| Previous Message | Craig Ringer | 2014-09-02 04:42:42 | Re: PL/pgSQL 2 |