Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 69664475E97 for ; Thu, 16 Jan 2003 04:55:36 -0500 (EST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id A5999475D93 for ; Thu, 16 Jan 2003 04:55:35 -0500 (EST) Received: from klaster.net (pe26.krakow.cvx.ppp.tpnet.pl [213.76.40.26]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 512FB2B84B; Thu, 16 Jan 2003 10:52:22 +0100 (CET) Message-ID: <3E12BBEA.5020105@klaster.net> Date: Wed, 01 Jan 2003 10:59:06 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; en-US; rv:1.2b) Gecko/20021016 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Roman Fail Cc: pgsql-performance@postgresql.org Subject: Re: 7.3.1 New install, large queries are slow References: <9B1C77393DED0D4B9DAA1AA1742942DA0E4BFD@pos_pdc.posportal.com> In-Reply-To: <9B1C77393DED0D4B9DAA1AA1742942DA0E4BFD@pos_pdc.posportal.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/136 X-Sequence-Number: 783 Roman Fail wrote: > The same result columns and JOINS are performed all day with variations on the WHERE clause; Are there any where clauses which all of theses variation have? If yes - query can be reordered to contain explicit joins for these clauses and to let Postgres to find best solution for other joins. I know, it is not best solution, but sometimes I prefer finding best join order by myself. I create then several views returning the same values, but manualy ordered for specific where clauses. Tomasz Myrta