From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
---|---|
To: | Mark Steben <msteben(at)autorevenue(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Question on partitioning |
Date: | 2006-11-10 17:39:16 |
Message-ID: | 129402.28483.qm@web31803.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> Thanks to all who responded to my question on querying on cluster index
> names.
> I have another question. We are considering partitioning 2 or 3 of our
> larger tables.
> Each has 12 million or more rows. We want to partition on customer_id and
> build
> Primary key indexes on each of the children partitions which inherit column
> characteristics
> From the master table. This would resolve any issues about queries on
> customer-id.
> My question is this: How would I handle a query that queries
> On another Non-partitioned column, say, ENTRY_DATE? Could I design an index
> On the master table that would reference ENTRY-DATE across partitions or
> will
> I need to build indexes and queries on each partition?
I haven't done too much partitioning yet, but this is where I would start looking first:
http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html
Regards,
Richard Broersma Jr.
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-11-10 18:35:46 | Re: Question on partitioning |
Previous Message | Mark Steben | 2006-11-10 16:29:55 | Question on partitioning |