X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 96021D95AE for ; Thu, 10 Nov 2005 12:34:11 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66102-09 for ; Thu, 10 Nov 2005 16:34:09 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.205]) by svr1.postgresql.org (Postfix) with ESMTP id 84E27D7BF7 for ; Thu, 10 Nov 2005 12:34:08 -0400 (AST) Received: by xproxy.gmail.com with SMTP id s14so638061wxc for ; Thu, 10 Nov 2005 08:34:08 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=ZhFNHfGrBigCVzRywyGgA4nigB5QiXQB6OhfSFoE70LIafy9R9UtJZVn9oQ1u9v992OT9gk3yGOIncnYilzU7uDjb2UP2WP2QnMFkOSCxECExDSeDhtyaWWRx2XP7AMtiKY6PGcrm2va9Si+CJJajkiAnplzSFeM95HvbP/XblM= Received: by 10.70.46.20 with SMTP id t20mr999986wxt; Thu, 10 Nov 2005 08:34:08 -0800 (PST) Received: by 10.70.87.11 with HTTP; Thu, 10 Nov 2005 08:34:07 -0800 (PST) Message-ID: <1d219a6f0511100834q12bef69ek803e29559a54fc15@mail.gmail.com> Date: Thu, 10 Nov 2005 11:34:08 -0500 From: Chris Hoover To: pgsql-admin@postgresql.org Subject: Partitioning in 8.1 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9207_31404299.1131640448255" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.772 required=5 tests=[AWL=0.129, HTML_00_10=0.642, HTML_MESSAGE=0.001] X-Spam-Score: 0.772 X-Spam-Level: X-Archive-Number: 200511/119 X-Sequence-Number: 19492 ------=_Part_9207_31404299.1131640448255 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Does anyone have a link to documents that describe the new partitioning tha= t is available in 8.1 (I look at the 8.1 docs but did not see any, but I may be blind :) )? I'd like to experiment with it and see if it can help with our data needs. For those interested: I need to be able to have a live oltp table partitioned based upon a key field or even better key fields. I really need it to be able to handle all oltp operations. Can the new partition system handle that (i.e. one partitioned table with insert, update, delete, and select statments thrown at it)? thanks, Chris ------=_Part_9207_31404299.1131640448255 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Does anyone have a link to documents that describe the new partitioning that is available in 8.1 (I look at the 8.1 docs but did not see any, but I may be blind :) )?

I'd like to experiment with it and see if it can help with our data needs.<= br>
For those interested:

I need to be able to have a live oltp table partitioned based upon a key field or even better key fields.  I really need it to be able to handle all oltp operations.  Can the new partition system handle that (i.e. one partitioned table with insert, update, delete, and select statments thrown at it)?

thanks,

Chris
------=_Part_9207_31404299.1131640448255--