X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 435B253572
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 10 Apr 2005 15:54:28 +0100 (BST)
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 62836-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 10 Apr 2005 14:54:26 +0000 (GMT)
Received: from web30504.mail.mud.yahoo.com (web30504.mail.mud.yahoo.com
	[68.142.200.117])
	by svr1.postgresql.org (Postfix) with SMTP id 041565356F
	for <pgsql-sql@postgresql.org>; Sun, 10 Apr 2005 15:54:25 +0100 (BST)
Received: (qmail 78734 invoked by uid 60001); 10 Apr 2005 14:54:29 -0000
Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	b=sT0CzZX1dFv/9Ja1mm+ioXDpxlSE/bMI0oQWj2L1Q6h3O8hO5Vui8w2RXDwEUo4m6K0csspjedKKMTWHT7/bZMG5c1OlINyAjQ2jHp0AoWAg5JNhsPGEv8BuD1Fc/JSeeQieVYidjiNTuQxymFMfaCuKn9ZFYqruI1R53ZF8SIc=
	;
Message-ID: <20050410145429.78732.qmail@web30504.mail.mud.yahoo.com>
Received: from [81.133.216.234] by web30504.mail.mud.yahoo.com via HTTP;
	Sun, 10 Apr 2005 07:54:29 PDT
Date: Sun, 10 Apr 2005 07:54:29 -0700 (PDT)
From: pankaj naug <pankajnaug@yahoo.com>
Subject: Re: subselect query time and loops problem 
To: pgsql-sql@postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>
In-Reply-To: 6667
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-2138393120-1113144869=:78226"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=2.542 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_ABUSE, FORGED_YAHOO_RCVD, HTML_40_50, HTML_MESSAGE
X-Spam-Level: **
X-Archive-Number: 200504/139
X-Sequence-Number: 21032

--0-2138393120-1113144869=:78226
Content-Type: text/plain; charset=us-ascii

Thanks Tom,
 
I am using version 7.3.4, having problems updating to postgres 8 because of cpanel problems.
 
regarding,
 
>Evidently one has been analyzed much more recently than the other,
because the estimated row counts are wildly different.
 
Both the explain/analyse queries has been run at the same time.
 
Best regards
Pankaj

		
---------------------------------
Yahoo! Mail Mobile
 Take Yahoo! Mail with you! Check email on your mobile phone.
--0-2138393120-1113144869=:78226
Content-Type: text/html; charset=us-ascii

<DIV>Thanks Tom,</DIV>
<DIV>&nbsp;</DIV>
<DIV>I am using version 7.3.4, having problems updating to postgres 8 because of cpanel problems.</DIV>
<DIV>&nbsp;</DIV>
<DIV>regarding,</DIV>
<DIV>&nbsp;</DIV>
<DIV>&gt;Evidently one has been analyzed much more recently than the other,<BR>because the estimated row counts are wildly different.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Both the explain/analyse queries has been run at the same time.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Best regards</DIV>
<DIV>Pankaj</DIV><p>
		<hr size=1>Yahoo! Mail Mobile<br> 
<a href="http://us.rd.yahoo.com/mail_us/taglines/mobile/*http://mobile.yahoo.com/learn/mail">Take Yahoo! Mail with you!</a> Check email on your mobile phone.
--0-2138393120-1113144869=:78226--