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<jgood...@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?


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to