X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B7617528F9 for ; Mon, 15 Aug 2005 11:54:15 -0300 (ADT) 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 22555-09 for ; Mon, 15 Aug 2005 14:54:14 +0000 (GMT) Received: from benny.care4all.dk (cpe.atm2-0-52453.0x50a4a22a.esnxx3.customer.tele.dk [80.164.162.42]) by svr1.postgresql.org (Postfix) with ESMTP id B54F75284A for ; Mon, 15 Aug 2005 11:54:12 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by benny.care4all.dk (Postfix) with ESMTP id 68916BEF6; Mon, 15 Aug 2005 16:54:15 +0200 (CEST) Received: from benny.care4all.dk ([127.0.0.1]) by localhost (benny [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26567-08; Mon, 15 Aug 2005 16:54:14 +0200 (CEST) Received: from [172.19.10.164] (x1-6-00-80-c8-03-a6-d7.k438.webspeed.dk [83.89.23.114]) by benny.care4all.dk (Postfix) with ESMTP id 97DF9BEF2; Mon, 15 Aug 2005 16:54:14 +0200 (CEST) Message-ID: <4300AC95.70204@pbnet.dk> Date: Mon, 15 Aug 2005 16:54:13 +0200 From: =?ISO-8859-1?Q?Poul_M=F8ller_Hansen?= User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Richard Huxton , pgsql-general@postgresql.org Subject: Re: Optimizing query References: <43005482.7020105@pbnet.dk> <43005CBD.5070703@archonet.com> <43006480.4000409@pbnet.dk> <25298.1124113567@sss.pgh.pa.us> In-Reply-To: <25298.1124113567@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at care4all.dk X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.079 required=5 tests=[AWL=0.029, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/730 X-Sequence-Number: 82138 > > You're not there yet: you want what Richard said, namely > I realized that it wasn't optimal for all nodes, namely those with a lot of rows. So you are absolutely right, I followed the suggestion of Richard and it works perfect. Thank you all, I learned a lesson of indexes today... Poul