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

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Alessandro Gagliardi <alessandro(at)path(dot)com>
Cc: Bartosz Dmytrak <bdmytrak(at)eranet(dot)pl>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Partitioning (Was: Foreign Key to an (abstract?) Parent Table)
Date: 2012-02-21 22:35:25
Message-ID: 4F441C2D.1030208@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Alessandro Gagliardi 2012-02-21 23:08:17 Re: Partitioning (Was: Foreign Key to an (abstract?) Parent Table)
Previous Message Alessandro Gagliardi 2012-02-21 22:18:05 Partitioning (Was: Foreign Key to an (abstract?) Parent Table)