From: Joshua Gooding <JGooding@ttitech.net>
To: pgsql-sql@postgresql.org
Subject: Re: question about partitioning
Date: Thu, 24 Jun 2010 15:51:21 -0400
Message-ID: <4C23B739.6070704@ttitech.net> (raw)
In-Reply-To: <8585BA53443004458E0BAA6134C5A7FB07BA649C@EGEXCMB01.oww.root.lcl>
References: <4C235807.5070509@ttitech.net>
<hvvs9b$vn2$1@reversiblemaps.ath.cx>
<4C23B28C.2080006@ttitech.net>
<8585BA53443004458E0BAA6134C5A7FB07BA649C@EGEXCMB01.oww.root.lcl>
I'm trying to figure out the logic behind the date parameters though. I
don't have to worry at all about partition size.
Joshua Gooding
On 6/24/2010 3:37 PM, Little, Douglas wrote:
> 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@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Joshua Gooding
> Sent: Thursday, June 24, 2010 2:31 PM
> To: pgsql-sql@postgresql.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@ttitech.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?
>>
>>
>>
>
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: JGooding@ttitech.net
Subject: Re: question about partitioning
In-Reply-To: <4C23B739.6070704@ttitech.net>
* 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