Question on partitioning

Поиск
Список
Период
Сортировка
От Mark Steben
Тема Question on partitioning
Дата
Msg-id 003201c704e5$74fb5a00$b501a8c0@D1RPQZB1
обсуждение исходный текст
Ответы Re: Question on partitioning  (Richard Broersma Jr <rabroersma@yahoo.com>)
Список 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@autorevenue.com]
Sent: Tuesday, November 07, 2006 3:18 PM
To: 'pgsql-admin@postgresql.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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Gergely CZUCZY
Дата:
Сообщение: Re: schemas and tablespaces
Следующее
От: Richard Broersma Jr
Дата:
Сообщение: Re: Question on partitioning