X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 24DCCD1C4DF for ; Thu, 24 Jul 2003 06:07:06 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 09559-10 for ; Thu, 24 Jul 2003 03:05:53 -0300 (ADT) Received: from www.sgbs.de (www.sgbs.de [62.225.75.154]) by svr1.postgresql.org (Postfix) with ESMTP id 728B2D1C944 for ; Thu, 24 Jul 2003 03:06:34 -0300 (ADT) From: =?iso-8859-15?q?J=F6rg=20Schulz?= To: pgsql-performance@postgresql.org Subject: Re: different query plan for same select Date: Thu, 24 Jul 2003 08:06:22 +0200 User-Agent: KMail/1.5.1 References: <200307231628.54295.jschulz@sgbs.de> <13276.1058973666@sss.pgh.pa.us> In-Reply-To: <13276.1058973666@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200307240806.22941.jschulz@sgbs.de> X-Virus-Scanned: by AMaViS X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/401 X-Sequence-Number: 2694 > > I'm not very familar with the output of the explain command but can you > > tell me why I get two different query plans? > > Judging from the suspiciously round numbers in the cost estimates, > you've never done a VACUUM ANALYZE on any of these tables. Try that and > then see what plans you get... Oops.. You were right! Thank you anyway. J=F6rg