X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1EC7655F07 for ; Sun, 20 Mar 2005 04:29:30 +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 56855-07 for ; Sun, 20 Mar 2005 04:29:28 +0000 (GMT) Received: from sunsite.dcc.uchile.cl (sunsite.dcc.uchile.cl [192.80.24.2]) by svr1.postgresql.org (Postfix) with ESMTP id A866A55CC9 for ; Sun, 20 Mar 2005 04:29:26 +0000 (GMT) Received: from anakena.dcc.uchile.cl (anakena [192.80.24.6]) by sunsite.dcc.uchile.cl (8.12.11/8.12.11) with ESMTP id j2K4THcn028331; Sun, 20 Mar 2005 00:29:17 -0400 (CLT) Received: by anakena.dcc.uchile.cl (Postfix, from userid 4151) id 5E9E65236B; Sun, 20 Mar 2005 00:29:17 -0400 (CLT) Date: Sun, 20 Mar 2005 00:29:17 -0400 From: Alvaro Herrera To: Tom Lane Cc: PFC , Josh Berkus , pgsql-performance@postgresql.org Subject: Re: What needs to be done for real Partitioning? Message-ID: <20050320042917.GA25831@dcc.uchile.cl> References: <200503191202.38089.josh@agliodbs.com> <20050319225624.GA8467@dcc.uchile.cl> <3404.1111277153@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3404.1111277153@sss.pgh.pa.us> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.352 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200503/383 X-Sequence-Number: 11088 On Sat, Mar 19, 2005 at 07:05:53PM -0500, Tom Lane wrote: > Alvaro Herrera writes: > > We probably also need multi-table indexes. > > As Josh says, that seems antithetical to the main point of partitioning, > which is to be able to rapidly remove (and add) partitions of a table. > If you have to do index cleaning before you can drop a partition, what's > the point of partitioning? Hmm. You are right, but without that we won't be able to enforce uniqueness on the partitioned table (we could only enforce it on each partition, which would mean we can't partition on anything else than primary keys if the tables have one). IMHO this is something to consider. -- Alvaro Herrera () "El hombre nunca sabe de lo que es capaz hasta que lo intenta" (C. Dickens)