Re: Partitioning Option?

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Partitioning Option?
Дата
Msg-id 20050223194842.GB20776@wolff.to
обсуждение исходный текст
Ответ на Re: Partitioning Option?  ("Tomeh, Husam" <htomeh@firstam.com>)
Список pgsql-admin
On Wed, Feb 23, 2005 at 10:54:50 -0800,
  "Tomeh, Husam" <htomeh@firstam.com> wrote:
> Thanks Josh, I'll check out the namespace concept.
>
> (I was referring to object partitioning. For instance, if I have a huge
> table with US counties as my partition key, I could create partitions
> within the same table based on the partition key (a US county for
> example). When querying, the engine will access the partition instead of
> the whole table to get the result set. This is provided in Oracle DB EE.
> So, I was wondering whether I can do similar thing in PostgreSQL since
> we're exploring PostgreSQL)

You have to do it by hand and you won't get the full savings.
The idea is to create tables for each partition. Then create a UNION ALL
view of the tables, incorporating the key condition that applies for
each table.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Partitioning Option?
Следующее
От: Bjoern Metzdorf
Дата:
Сообщение: invalid multibyte character for locale