On Jun 28, 2009, at 11:45 AM, Whit Armstrong wrote:
Thanks, Tom.
Let me give a little more detail on my actual data rather than the
simple example I sent.
I have a 60GB table of loan balances, which I've partitioned into 26
tables.
The loan id's are a sequence of 6 characters, so the part
Thanks, Tom.
Let me give a little more detail on my actual data rather than the
simple example I sent.
I have a 60GB table of loan balances, which I've partitioned into 26 tables.
The loan id's are a sequence of 6 characters, so the partitioning rule
I've used is the first character of the loan
Whit Armstrong writes:
> I have a simple example copied from the 8.3 manual on partitioning
> (http://www.postgresql.org/docs/8.3/interactive/ddl-partitioning.html).
> My question is, if you create a serial type in the parent table which
> is meant to be the primary key across all the partitions,
I have a simple example copied from the 8.3 manual on partitioning
(http://www.postgresql.org/docs/8.3/interactive/ddl-partitioning.html).
My question is, if you create a serial type in the parent table which
is meant to be the primary key across all the partitions, how does one
guarantee uniquene
