Re: What needs to be done for real Partitioning? - Mailing list pgsql-performance

From Tom Lane
Subject Re: What needs to be done for real Partitioning?
Date
Msg-id 4507.1111294073@sss.pgh.pa.us
Whole thread Raw
In response to Re: What needs to be done for real Partitioning?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: What needs to be done for real Partitioning?
List pgsql-performance
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> Hmm.  You are right, but without that we won't be able to enforce
> uniqueness on the partitioned table (we could only enforce it on each
> partition, which would mean we can't partition on anything else than
> primary keys if the tables have one).  IMHO this is something to
> consider.

Well, partitioning on the primary key would be Good Enough for 95% or
99% of the real problems out there.  I'm not excited about adding a
large chunk of complexity to cover another few percent.

            regards, tom lane

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: What needs to be done for real Partitioning?
Next
From: Greg Stark
Date:
Subject: Re: What needs to be done for real Partitioning?