Re: question about partitioning

From: "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com>
To: Joshua Gooding <JGooding(at)ttitech(dot)net>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: question about partitioning
Date: 2010-06-24 19:37:41
Message-ID: 8585BA53443004458E0BAA6134C5A7FB07BA649C@EGEXCMB01.oww.root.lcl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I don't know how you would partition by size.
Date is a good candidate, and roughly wouldn't you have the same number of tx's/day
You'll only benefit query performance if you include the partitioning column in the where clause.
If you have a surrogate pk, you could also use this to partition. Using a range key you would probably get relatively constant partition size.

Doug

-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Joshua Gooding
Sent: Thursday, June 24, 2010 2:31 PM
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] question about partitioning

I think I replied to the individual and not to the list before....

As of right now size doesn't matter, I need to partition it via a date.
10 partitions, 10 weeks worth of data.

I was thinking of partitioning it off every 32GB of data, but that is
not exactly what I am looking to do.

Joshua Gooding

On 6/24/2010 11:06 AM, Jasen Betts wrote:
> On 2010-06-24, Joshua Gooding<JGooding(at)ttitech(dot)net> wrote:
>
>> Right now I am in the process of migrating an Oracle DB over to Postgres
>> 8.4.3. The table is partitioned by size. Is there anyway to partition
>> the new postgres table by size? I created some partitions for the new
>> table, but I didn't give postgres any rules to partition by, so I have
>> 250M test records in one table. Any ideas or thoughts on how to build
>> the rules for the table by size would be greatly appreciated.
>>
> by size of what?
>
>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Joshua Gooding 2010-06-24 19:51:21 Re: question about partitioning
Previous Message Joshua Gooding 2010-06-24 19:31:24 Re: question about partitioning