| From: | Petru Ghita <petrutz(at)venaver(dot)info> |
|---|---|
| To: | Joshua Gooding <JGooding(at)ttitech(dot)net>, pgsql-sql mailing list <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: question about partitioning |
| Date: | 2010-06-24 20:17:53 |
| Message-ID: | 4C23BD71.40706@venaver.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| Attachment | Content-Type | Size |
|---|---|---|
| 0x7CF29D04.asc | application/pgp-keys | 2.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gerardo Herzig | 2010-06-24 22:26:14 | differences between function returning 'setof table' and 'table' |
| Previous Message | Joshua Gooding | 2010-06-24 19:51:21 | Re: question about partitioning |