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 143D28BA02B for ; Wed, 9 Feb 2005 17:42:15 +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 24489-09 for ; Wed, 9 Feb 2005 17:41:56 +0000 (GMT) Received: from davinci.ethosmedia.com (server227.ethosmedia.com [209.128.84.227]) by svr1.postgresql.org (Postfix) with ESMTP id 384928B9FE3 for ; Wed, 9 Feb 2005 17:41:56 +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 7007495; Wed, 09 Feb 2005 09:43:41 -0800 From: Josh Berkus Organization: Aglio Database Solutions To: Silke Trissl Subject: Re: Tell postgres which index to use? Date: Wed, 9 Feb 2005 09:41:01 -0800 User-Agent: KMail/1.6.2 Cc: pgsql-performance@postgresql.org References: <420A3309.5040507@informatik.hu-berlin.de> In-Reply-To: <420A3309.5040507@informatik.hu-berlin.de> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200502090941.01447.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.013 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/142 X-Sequence-Number: 10471 Silke, > is there a way to tell Postgres which index to use when a query is > issued in 7.4.2? PostgreSQL adjusts usage through global parameters, statistics, and periodic ANALYZE. Please post an EXPLAIN ANALYZE (not just EXPLAIN) for your query and people on this list can help you with your specific problem. -- Josh Berkus Aglio Database Solutions San Francisco