X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C97C2D8626 for ; Sun, 9 Oct 2005 05:59:53 -0300 (ADT) 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 90868-01 for ; Sun, 9 Oct 2005 08:59:50 +0000 (GMT) Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by svr1.postgresql.org (Postfix) with ESMTP id 03585D82E4 for ; Sun, 9 Oct 2005 05:59:52 -0300 (ADT) Received: from 192.168.0.3 (unknown [84.12.188.233]) by smtp.nildram.co.uk (Postfix) with ESMTP id 1346424E6FF for ; Sun, 9 Oct 2005 09:59:52 +0100 (BST) Subject: Inheritance and Partitioning From: Simon Riggs To: pgsql-docs@postgresql.org Content-Type: text/plain Organization: 2nd Quadrant Date: Sun, 09 Oct 2005 09:59:52 +0100 Message-Id: <1128848392.8300.205.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-3) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.049 required=5 tests=[AWL=-0.001, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/21 X-Sequence-Number: 3266 I'm currently doing the docs for CE & Partitioning. The ddl.sgml chapter had a section on Inheritance. I'm expanding that section and splitting it into two: INHERITANCE & PARTITIONING 1. Table Partitioning Existing chapter, but with more detail of a general nature that will be important information when we discuss... 2. Basic Partitioning using Constraint Exclusion How to enhance inheritance with constraints to allow CE. How that works to provide basic partitioning, with examples and long list of caveats. Any comments while I'm in progress? You will of course have another chance to comment when I complete the patch. Best Regards, Simon Riggs