Skip site navigation (1) Skip section navigation (2)

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

From: Alessandro Gagliardi <alessandro(at)path(dot)com>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Partitioning (Was: Foreign Key to an (abstract?) Parent Table)
Date: 2012-02-21 23:08:17
Message-ID: CAAB3BBLgDQPnH=tdxyJOaa8KT_B_qK+t5CWaHw_V-atMWQ9KAw@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(at)pinpointresearch(dot)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/<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<http://www.postgresql.org/docs/current/static/ddl-partitioning.html>
>
> Cheers,
> Steve
>

In response to

Responses

pgsql-novice by date

Next:From: Steve CrawfordDate: 2012-02-21 23:28:48
Subject: Re: Partitioning (Was: Foreign Key to an (abstract?) Parent Table)
Previous:From: Steve CrawfordDate: 2012-02-21 22:35:25
Subject: Re: Partitioning (Was: Foreign Key to an (abstract?) Parent Table)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group