Postgres Pro
Downloads
Home   >   mailing lists

Re: Partitioning (Was: Foreign Key to an (abstract?) Parent Table) - Mailing list pgsql-novice

From Steve Crawford
Subject Re: Partitioning (Was: Foreign Key to an (abstract?) Parent Table)
Date
Msg-id 4F441C2D.1030208@pinpointresearch.com
Whole thread Raw
In response to Partitioning (Was: Foreign Key to an (abstract?) Parent Table)  (Alessandro Gagliardi <alessandro@path.com>)
Responses Re: Partitioning (Was: Foreign Key to an (abstract?) Parent Table)
List pgsql-novice
Tree view 
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 by date:

Previous
From: Alessandro Gagliardi
Date:
Subject: Partitioning (Was: Foreign Key to an (abstract?) Parent Table)
Next
From: Alessandro Gagliardi
Date:
Subject: Re: Partitioning (Was: Foreign Key to an (abstract?) Parent Table)