X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2E439474E53 for ; Mon, 17 Feb 2003 13:12:21 -0500 (EST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id 88F85474E42 for ; Mon, 17 Feb 2003 13:12:20 -0500 (EST) Received: from klaster.net (ph16.krakow.cvx.ppp.tpnet.pl [217.99.208.16]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 2CD7C2B1DA; Mon, 17 Feb 2003 19:03:28 +0100 (CET) Message-ID: <3E5125E0.3020103@klaster.net> Date: Mon, 17 Feb 2003 19:11:44 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; PL; rv:1.1) Gecko/20020826 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Brad Hilton Cc: pgsql-sql@postgresql.org Subject: Re: sub-query optimization References: <1045246939.29966.22.camel@aragorn.vpop.net> <20030214192113.GA26987@serwer> <1045251747.29974.45.camel@aragorn.vpop.net> <20030214205922.M13630@klaster.net> <1045262371.29955.124.camel@aragorn.vpop.net> <20030215095213.M15935@klaster.net> <1045502407.7192.10.camel@aragorn.vpop.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/373 X-Sequence-Number: 11771 Brad Hilton wrote: > -------------------------------- > Merge Join (cost=26538.07..30754.75 rows=20000 width=191) (actual > time=1736.36..3079.64 rows=100000 loops=1) It looks like you didn't vacuum analyze database before explain analyze. Can you do this and send explain analyze once again? Look at the "actual time" showing which operation takes the most time. Regards, Tomasz Myrta