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 171518B9ED0 for ; Wed, 23 Feb 2005 19:33:24 +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 10425-04 for ; Wed, 23 Feb 2005 19:33:20 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 7E2E08B9EA8 for ; Wed, 23 Feb 2005 19:33:20 +0000 (GMT) Received: (qmail 20943 invoked by uid 500); 23 Feb 2005 19:48:42 -0000 Date: Wed, 23 Feb 2005 13:48:42 -0600 From: Bruno Wolff III To: "Tomeh, Husam" Cc: "Joshua D. Drake" , pgsql-admin@postgresql.org Subject: Re: Partitioning Option? Message-ID: <20050223194842.GB20776@wolff.to> Mail-Followup-To: "Tomeh, Husam" , "Joshua D. Drake" , pgsql-admin@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/269 X-Sequence-Number: 16437 On Wed, Feb 23, 2005 at 10:54:50 -0800, "Tomeh, Husam" wrote: > Thanks Josh, I'll check out the namespace concept. > > (I was referring to object partitioning. For instance, if I have a huge > table with US counties as my partition key, I could create partitions > within the same table based on the partition key (a US county for > example). When querying, the engine will access the partition instead of > the whole table to get the result set. This is provided in Oracle DB EE. > So, I was wondering whether I can do similar thing in PostgreSQL since > we're exploring PostgreSQL) You have to do it by hand and you won't get the full savings. The idea is to create tables for each partition. Then create a UNION ALL view of the tables, incorporating the key condition that applies for each table.