about partitioning - Mailing list pgsql-general

From Joao Ferreira gmail
Subject about partitioning
Date
Msg-id 1221133620.6676.50.camel@jmf-ubuntu
Whole thread Raw
Responses Re: about partitioning  (Robert Treat <robert@omniti.com>)
List pgsql-general
Hello all,

my application is coming to a point on which 'partitioning' seems to be
the solution for many problems:

- query speed up
- data elimination speed up



I'dd like to get the feeling of it by talking to people who use
partitioning, in general..

- good, bad,
- hard to manage, easy to manage,
- processing over-head during INSERT/UPDATE,
- stability/compatibility of pg_dump and restore operations,
- how many partitions would be reasonable for read _and_ write  access
optimal speed;

thx
joao



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: No error when column doesn't exist
Next
From: Tom Lane
Date:
Subject: Re: initdb memory segment creation error