Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 205A263350D for ; Thu, 24 Jun 2010 12:41:20 -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 93976-07 for ; Thu, 24 Jun 2010 15:41:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtpcorp.com (smtpcorp.com [67.192.120.76]) by mail.postgresql.org (Postfix) with ESMTP id 6C1446334F8 for ; Thu, 24 Jun 2010 12:41:11 -0300 (ADT) DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=smtpcorp.com; s=main; h=Content-Transfer-Encoding:Content-Type:Mime-Version:References:Message-ID:Date:Subject:From:To; bh=dBTo03IazwFc3GGfFfkSYE4Za2bSgnK0V5QBbxX/jw4=; b=kY+2WXjN8n21q8N8l86bYTlBVlW/U76QJxx1hCye9pd9ONLpGzkaMlGNGSmHv07x5sQ4MNhbXAhxatphTBZ2AJrTJCd4zVzGtj1cO+Rn3gyIbILqG/dBqBTaLsZGo9tP; Received: from ip-118-90-135-50.xdsl.xnet.co.nz ([118.90.135.50] helo=gonzo) by smtpcorp.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.70) id 1ORoW9-0008WV-CQ; mid 144 for pgsql-sql@postgresql.org; Thu, 24 Jun 2010 15:40:46 +0000 Received: from news by gonzo with local (Exim 4.69) (envelope-from ) id 1ORo0T-0008Tn-Mw for pgsql-sql@postgresql.org; Fri, 25 Jun 2010 03:06:21 +1200 To: pgsql-sql@postgresql.org Path: not-for-mail From: Jasen Betts Newsgroups: gmane.comp.db.postgresql.sql Subject: Re: question about partitioning Date: 24 Jun 2010 15:06:19 GMT Organization: Dis (not Dat) Organisation Lines: 9 Message-ID: References: <4C235807.5070509@ttitech.net> NNTP-Posting-Host: localhost Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: reversiblemaps.ath.cx 1277391979 32482 127.0.0.1 (24 Jun 2010 15:06:19 GMT) X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a +M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W; (T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q; 8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^ User-Agent: slrn/pre1.0.0-2 (Linux) X-Smtpcorp-Track: 5140638.1.62833523 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-5 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201006/77 X-Sequence-Number: 34268 On 2010-06-24, Joshua Gooding 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?