'Range partitioning in PGSQL'

Поиск

Список

Период

Сортировка

От	Saseendra Babu
Тема	'Range partitioning in PGSQL'
Дата	11 апреля 2011 г. 15:42:56
Msg-id	2FD8EC4D62BF40BE96DC586406F80612@ksbabu1 обсуждение исходный текст
Ответы	Re: 'Range partitioning in PGSQL' Re: 'Range partitioning in PGSQL'
Список	pgsql-novice

Дерево обсуждения

'Range partitioning in PGSQL'

Hello

Is there as in oracle?

My problem is as follows.

I have telephone_ subscriber table with tel no as Pkey

As the table has to contain millions of rows, I have to partition the table in to multiple partitions based on range of tel no.

( At present we did it with inheritance. but the problem found is: we have to insert rows in to each child table by referring the table name exclusively ,

based on range of tel nos, keeping the parent table empty.)

What we require is as follows.

In the insert statement we shall specify only the table name ( not the partition name)
The rows are be populated in to the corresponding partions.
In select also we should only the table name ( not the partition name). rows are to be retrieved from corresponding partitions.
While using partition by inheritance, we have to specify the partition, ie child table name.

Waiting for your valued suggestions

Saseendra Babu K

Вложения

saseendra@cdactvm.in.vcf

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

'Range partitioning in PGSQL'

Вложения