Re: question about partitioning - Mailing list pgsql-sql

From Joshua Gooding
Subject Re: question about partitioning
Date
Msg-id 4C23B28C.2080006@ttitech.net
Whole thread Raw
In response to Re: question about partitioning  (Jasen Betts <jasen@xnet.co.nz>)
Responses Re: question about partitioning
List pgsql-sql
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?
>
>    


pgsql-sql by date:

Previous
From: Bryan White
Date:
Subject: Re: ORDER BY is case insensitive
Next
From: "Little, Douglas"
Date:
Subject: Re: question about partitioning