Re: Primary Key Increment Doesn't Seem Correct Under Table Partition

On 29 Jan 2010, at 1:56, Yan Cheng Cheok wrote:

> Isn't the primary constraint will implicitly create an index for day already?
>
> PRIMARY KEY (advertiser_id, day),


Yes, but it's not a very efficient index to look for values of day if you don't provide a value for advertiser_id as
well.See http://www.postgresql.org/docs/8.4/interactive/indexes-multicolumn.html 

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4b62d2e810751877882363!