X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2F99F9DCB8A for ; Wed, 22 Mar 2006 15:19:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 19350-10 for ; Wed, 22 Mar 2006 15:19:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from calvin.slamb.org (calvin.slamb.org [216.136.66.56]) by postgresql.org (Postfix) with ESMTP id 12D9A9DCB28 for ; Wed, 22 Mar 2006 15:19:31 -0400 (AST) Received: by calvin.slamb.org (Postfix, from userid 103) id 219FF7031A; Wed, 22 Mar 2006 13:19:32 -0600 (CST) Received: from [129.255.176.239] (host176-239.uihc.uiowa.edu [129.255.176.239]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by calvin.slamb.org (Postfix) with ESMTP id EFCE2702F8; Wed, 22 Mar 2006 13:19:30 -0600 (CST) Message-ID: <4421A342.7070302@visualdistortion.org> Date: Wed, 22 Mar 2006 13:19:30 -0600 From: Jeffrey Melloy User-Agent: Mozilla Thunderbird 1.0.5 (Windows/20050711) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Maciej Piekielniak Cc: pgsql-sql@postgresql.org Subject: Re: How to optimize this query? References: <827987076.20060322181715@isb.com.pl> <684362e10603220958s2dac37cfp@mail.gmail.com> <1731392587.20060322191801@isb.com.pl> <684362e10603221027t354b079bh@mail.gmail.com> <684362e10603221032t4b07f5edu@mail.gmail.com> <672339640.20060322200740@isb.com.pl> In-Reply-To: <672339640.20060322200740@isb.com.pl> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.068 required=5 tests=[AWL=0.068] X-Spam-Score: 0.068 X-Spam-Level: X-Archive-Number: 200603/362 X-Sequence-Number: 24708 Maciej Piekielniak wrote: >Hello Markus, > >Oryginal query return 7881 rows , your query only 729 rows. > > > But it's faster!