From: Petru Ghita <petrutz@venaver.info>
To: Joshua Gooding <JGooding@ttitech.net>
To: pgsql-sql mailing list <pgsql-sql@postgresql.org>
Subject: Re: question about partitioning
Date: Thu, 24 Jun 2010 22:17:53 +0200
Message-ID: <4C23BD71.40706@venaver.info> (raw)
In-Reply-To: <4C235807.5070509@ttitech.net>
References: <4C235807.5070509@ttitech.net>
There is no partitioning by size that I know of but at:
http://www.postgresql.org/docs/8.4/interactive/ddl-partitioning.html
there is very good documentation on the topic.
As of this last weekend I had myself to do some testing with
partitioning in Postgres 8.4. I had 7000 items. For each of them I
stored 6 variables (smallint) for each hour quarter. Test data was
generated for 5 years. That gave me 210336 records per id per 5 years
period and a total of 1,472,352,000 records. This is taking about 33MB
per partition table and a total of 231GB. Doing something like a
grouping by the id and summing up the values of 10 ids takes about 2.5
seconds, which looks to me like a quite a nice performance.
Petru Ghita
On 24/06/2010 15:05, Joshua Gooding wrote:
> rules for
Attachments:
[application/pgp-keys] 0x7CF29D04.asc (2.8K, ../4C23BD71.40706@venaver.info/2-0x7CF29D04.asc)
download
[application/pgp-signature] signature.asc (258B, ../4C23BD71.40706@venaver.info/3-signature.asc)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: petrutz@venaver.info, JGooding@ttitech.net
Subject: Re: question about partitioning
In-Reply-To: <4C23BD71.40706@venaver.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox