Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 46C0B63275E for ; Thu, 24 Jun 2010 10:05:24 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 41830-03 for ; Thu, 24 Jun 2010 13:05:15 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx.ttitech.net (xciv.ttitech.net [65.202.253.94]) by mail.postgresql.org (Postfix) with ESMTP id 23ABC63271B for ; Thu, 24 Jun 2010 10:05:16 -0300 (ADT) Received: from [172.30.249.253] (tti88 [65.202.253.88]) by mx.ttitech.net (Postfix) with ESMTPSA id 7503A6841C for ; Thu, 24 Jun 2010 09:05:11 -0400 (EDT) Message-ID: <4C235807.5070509@ttitech.net> Date: Thu, 24 Jun 2010 09:05:11 -0400 From: Joshua Gooding User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.10) Gecko/20100512 Thunderbird/3.0.5 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: question about partitioning Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-5 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201006/76 X-Sequence-Number: 34267 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. -- Joshua Gooding Software Engineer TTi Technologies Wheeling, WV 26003 w: 304-233-5680 x 308 c: 304-794-8341