Re: Auto Partitioning - Mailing list pgsql-hackers

From Markus Schiltknecht
Subject Re: Auto Partitioning
Date
Msg-id 4613FDAB.6080501@bluegap.ch
Whole thread Raw
In response to Re: Auto Partitioning  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Auto Partitioning  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
Hi,

Joshua D. Drake wrote:
> If we don't have multi-table indexes how do we enforce a primary key 
> against a partitioned set?

The executor would have to be clever enough to not do a single index 
scan, but possibly scan through multiple indexes when asking for 
uniqueness, depending on the partitioning rule set.

Regards

Markus



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Auto Partitioning
Next
From: Markus Schiltknecht
Date:
Subject: Re: Auto Partitioning