From: Joshua Gooding <JGooding@ttitech.net>
To: pgsql-sql@postgresql.org
Subject: question about partitioning
Date: Thu, 24 Jun 2010 09:05:11 -0400
Message-ID: <4C235807.5070509@ttitech.net> (raw)
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
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: <4C235807.5070509@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