Re: Partitioning (Was: Foreign Key to an (abstract?) Parent Table)

Поиск
Список
Период
Сортировка
От Alessandro Gagliardi
Тема Re: Partitioning (Was: Foreign Key to an (abstract?) Parent Table)
Дата
Msg-id CAAB3BBLgDQPnH=tdxyJOaa8KT_B_qK+t5CWaHw_V-atMWQ9KAw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Partitioning (Was: Foreign Key to an (abstract?) Parent Table)  (Steve Crawford <scrawford@pinpointresearch.com>)
Ответы Re: Partitioning (Was: Foreign Key to an (abstract?) Parent Table)  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-novice
Дерево обсуждения
That is, indeed, where I started. The fact that it does not show how to automatically generate new partitions makes it somewhat....

On Tue, Feb 21, 2012 at 2:35 PM, Steve Crawford <scrawford@pinpointresearch.com> wrote:
On 02/21/2012 02:18 PM, Alessandro Gagliardi wrote:
...

On a related note, since seen_its is such a huge table, I'm thinking of partitioning it. The best web page I could find on that subject was http://www.fuzzy.cz/en/articles/automatic-management-of-partitions-in-postgresql/ but I'm hoping someone might be able to direct me to something better.

I'd start with the PostgreSQL manual:
http://www.postgresql.org/docs/current/static/ddl-partitioning.html

Cheers,
Steve

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

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: Partitioning (Was: Foreign Key to an (abstract?) Parent Table)
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: Partitioning (Was: Foreign Key to an (abstract?) Parent Table)