From: | "Mark Steben" <msteben(at)autorevenue(dot)com> |
---|---|
To: | "'Mark Steben'" <msteben(at)autorevenue(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Question on partitioning |
Date: | 2006-11-10 16:29:55 |
Message-ID: | 003201c704e5$74fb5a00$b501a8c0@D1RPQZB1 |
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?
Thank you for your time,
Mark Steben
_____
From: Mark Steben [mailto:msteben(at)autorevenue(dot)com]
Sent: Tuesday, November 07, 2006 3:18 PM
To: 'pgsql-admin(at)postgresql(dot)org'
Subject: Question
I am very new to PostgreSQL. Is it appropriate to pose questions to this
email list?
I am trying to come up with a query that will list the names of the database
indexes that
Have been chosen as clustering indexes. I know I can get the INDEXRELID
from PG.INDEX
But have yet to figure out how to get the index name from there. Any help
would be appreciated.
And, if this is not an appropriate forum to ask questions please tell me.
Thank you,
Mark Steben
AutoRevenue
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2006-11-10 17:39:16 | Re: Question on partitioning |
Previous Message | Gergely CZUCZY | 2006-11-10 15:38:47 | Re: schemas and tablespaces |