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 6D1D4568C6 for ; Mon, 21 Mar 2005 17:55: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 78470-01 for ; Mon, 21 Mar 2005 17:55:28 +0000 (GMT) Received: from davinci.ethosmedia.com (server227.ethosmedia.com [209.128.84.227]) by svr1.postgresql.org (Postfix) with ESMTP id 6F2D4568C3 for ; Mon, 21 Mar 2005 17:55:28 +0000 (GMT) X-EthosMedia-Virus-Scanned: no infections found Received: from [63.195.55.98] (account josh@agliodbs.com HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 7151254; Mon, 21 Mar 2005 09:57:19 -0800 From: Josh Berkus Organization: Aglio Database Solutions To: "Stacy White" Subject: Re: What needs to be done for real Partitioning? Date: Mon, 21 Mar 2005 09:55:03 -0800 User-Agent: KMail/1.6.2 Cc: "Tom Lane" , "Greg Stark" , "Alvaro Herrera" , "PFC" , References: <200503191202.38089.josh@agliodbs.com> <871xa9fyn4.fsf@stark.xeocode.com> <007401c52dd8$73395450$0200a8c0@grownups> In-Reply-To: <007401c52dd8$73395450$0200a8c0@grownups> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200503210955.03083.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.011 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/421 X-Sequence-Number: 11126 Stacy, > Luckily they that had the chance to work with a truly fantastic DBA (the > author of an Oracle Press performance tuning book even) before they could > switch back. He convinced them to make some of their indexes global. > Performance dramatically improved (compared with both the unpartitioned > schema, and the partitioned-and-locally-indexed schema), and they've since > stayed with partitioned tables and a mix of local and global indexes. Hmmm. Wouldn't Greg's suggestion of a bitmap index which holds information on what values are found in what partition also solve this? Without 1/2 of the overhead imposed by global indexes? I can actually see such a bitmap as being universally useful to the partitioning concept ... for one, it would resolve the whole "partition on {value}" issue. -- Josh Berkus Aglio Database Solutions San Francisco