X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8BB3356537 for ; Wed, 9 Mar 2005 15:02:43 +0000 (GMT) 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 40908-07 for ; Wed, 9 Mar 2005 15:02:38 +0000 (GMT) Received: from window.monsterlabs.com (window.monsterlabs.com [216.183.105.176]) by svr1.postgresql.org (Postfix) with SMTP id E29B45652D for ; Wed, 9 Mar 2005 15:02:36 +0000 (GMT) Received: (qmail 20669 invoked from network); 9 Mar 2005 15:02:39 -0000 Received: from host-209.149.56.238.nashville.net (HELO ?10.0.1.2?) (209.149.56.238) by 0 with SMTP; 9 Mar 2005 15:02:39 -0000 In-Reply-To: References: Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit Cc: "'pgsql-admin@postgresql.org'" From: Thomas F.O'Connell Subject: Re: Table Partitioning Date: Wed, 9 Mar 2005 09:02:39 -0600 To: Ken Reid X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/125 X-Sequence-Number: 16623 Ken, Table partitioning doesn't really exist, to the best of my knowledge, but tablespaces, which are new to 8.0, allow for partitioning of data (individual tables, indexes) across multiple locations on disk. See http://www.postgresql.org/docs/8.0/static/sql-createtablespace.html -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Mar 3, 2005, at 3:56 PM, Ken Reid wrote: > I am new to postgres and was wondering if table partitioning > is supported in Postgres. And if so what version and where can > I find documentation on it. > > - Thank You > > - Ken Reid