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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
