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 7316BDA7BA for ; Thu, 10 Nov 2005 13:26:52 -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 43708-04 for ; Thu, 10 Nov 2005 17:26:50 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.200]) by svr1.postgresql.org (Postfix) with ESMTP id B5CFFDA5B3 for ; Thu, 10 Nov 2005 13:26:50 -0400 (AST) Received: by xproxy.gmail.com with SMTP id s14so655100wxc for ; Thu, 10 Nov 2005 09:26:50 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=uhVMOImy9EOqLHfh27XHfw/qrsKKHTg2EuZ5y2AkCBdKn8xHggryDfCvqJdbBo8jkUSPyEbOC7pAXUBTZhmO9+b6OhkkABTjij75oV4LDVNEvIPLHC9efFxO1nT4UrQc1R4yhKIQWI434civH7dW18X7cqgGG8MIhbXdte8mdCU= Received: by 10.70.6.2 with SMTP id 2mr1025173wxf; Thu, 10 Nov 2005 09:26:50 -0800 (PST) Received: by 10.70.87.11 with HTTP; Thu, 10 Nov 2005 09:26:50 -0800 (PST) Message-ID: <1d219a6f0511100926s83162dfl59a1cfe2ac49b3a@mail.gmail.com> Date: Thu, 10 Nov 2005 12:26:50 -0500 From: Chris Hoover To: Tom Lane Subject: Re: Partitioning in 8.1 Cc: pgsql-admin@postgresql.org In-Reply-To: <9894.1131641691@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10011_9768408.1131643610541" References: <1d219a6f0511100834q12bef69ek803e29559a54fc15@mail.gmail.com> <9894.1131641691@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.441 required=5 tests=[AWL=0.440, HTML_MESSAGE=0.001] X-Spam-Score: 0.441 X-Spam-Level: X-Archive-Number: 200511/123 X-Sequence-Number: 19496 ------=_Part_10011_9768408.1131643610541 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 11/10/05, Tom Lane wrote: > > Chris Hoover writes: > > 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 :) )? > > http://www.postgresql.org/docs/8.1/static/ddl-partitioning.html > > It's not really a new feature in terms of there being any new syntax, > it's just that there's more optimizer support for a certain way of > doing things. > > I'm not sure that this really belongs in the DDL chapter ... seems like > Performance Tips might have been a more appropriate heading to put it > under. > > regards, tom lane > Thanks for the link. When I originally tried to find it on Tues/Wed the search did not seem to work with 8.1 and I did not see in looking through the index. Chris ------=_Part_10011_9768408.1131643610541 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

On 11/10/05, Tom Lane <tgl@sss.pgh.= pa.us> wrote:
Chris Hoover <revoohc@gmail.com= > writes:
> 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 :) )?

http://www.postgresql.org/docs/8.1/static/d= dl-partitioning.html

It's not really a new feature in terms of t= here being any new syntax,
it's just that there's more optimizer support for a certain way of
d= oing things.

I'm not sure that this really belongs in the DDL chapte= r ... seems like
Performance Tips might have been a more appropriate hea= ding to put it
under.

         &nb= sp;            =   regards, tom lane
Thanks for the link.  When I originally tried to find it on Tues/Wed the search did not seem to work with 8.1 and I did not see in looking through the index.

Chris
------=_Part_10011_9768408.1131643610541--