Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 3AB851337BC8
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 23 Mar 2011 07:12:02 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 02434-03
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 23 Mar 2011 10:11:53 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f46.google.com (mail-fx0-f46.google.com
	[209.85.161.46])
	by mail.postgresql.org (Postfix) with ESMTP id 588A91337BBB
	for <pgsql-performance@postgresql.org>;
	Wed, 23 Mar 2011 07:11:50 -0300 (ADT)
Received: by fxm17 with SMTP id 17so7181440fxm.19
	for <pgsql-performance@postgresql.org>;
	Wed, 23 Mar 2011 03:11:50 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:message-id:date:from:user-agent:mime-version:to
	:cc:subject:references:in-reply-to:content-type;
	bh=sYPN+oNeJoetj0wob4QyXci2t38KDDOxWos74iM7Myg=;
	b=CC7QSUoojzpE22ZX8Pdtz5FWvLJRoWoCy5rup1YX/9ZzjNuhDMJ+KKbS7gsU55i8Xn
	UQKprSxjtl5YJC1K+YQK+PGvjsUYYrJBMod6qVuRLGGDmjx4rVoiv3OhSAxdc45Zn8KB
	IP/dUWrxgr6QCzwnNMwsdRSAOue3J3n9BoDL8=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type;
	b=wImDbLWvD+IleqFZp5SzmODtBs4PYUjDBvvLETdyXjbnO27AHORol7ugB98WTyRBy4
	Y84mglubJl32mulNXUjoXwdAMhH40nYLXM08gFFwvqrCCssKLhDhIVegScF6DQfQogsK
	+tcS0pRgSAHZRaR3FamhpWPPEspQWGKpl3f1I=
Received: by 10.223.127.210 with SMTP id h18mr7758942fas.46.1300875110556;
	Wed, 23 Mar 2011 03:11:50 -0700 (PDT)
Received: from [10.1.1.57] (skuns.zoral.com.ua [91.193.166.194])
	by mx.google.com with ESMTPS id 14sm1895048fae.23.2011.03.23.03.11.47
	(version=TLSv1/SSLv3 cipher=OTHER);
	Wed, 23 Mar 2011 03:11:49 -0700 (PDT)
Message-ID: <4D89C778.6050805@gmail.com>
Date: Wed, 23 Mar 2011 12:12:08 +0200
From: Vitalii Tymchyshyn <tivv00@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.14) Gecko/20110223 Lightning/1.0b2 Thunderbird/3.1.8
MIME-Version: 1.0
To: Adarsh Sharma <adarsh.sharma@orkash.com>
CC: pgsql-performance@postgresql.org
Subject: Re: Re-Reason of Slowness of Query
References: <4D89BABF.4080806@orkash.com> <4D89BCD6.6040604@gmail.com>
	<4D89C704.5080603@orkash.com>
In-Reply-To: <4D89C704.5080603@orkash.com>
Content-Type: multipart/alternative;
	boundary="------------030505040508020407020305"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.345 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=1.553,
	FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201103/263
X-Sequence-Number: 42942

This is a multi-part message in MIME format.
--------------030505040508020407020305
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

23.03.11 12:10, Adarsh Sharma ???????(??):
> I just want to retrieve that id 's from page_content which do not have 
> any entry in clause2 table.
>
Then
select distinct(p.crawled_page_id) from page_content p
  where NOT EXISTS (select 1 from  clause2 c where c.source_id = 
p.crawled_page_id);
is correct query.

Best regards, Vitalii Tymchyshyn.

--------------030505040508020407020305
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    23.03.11 12:10, Adarsh Sharma &#1085;&#1072;&#1087;&#1080;&#1089;&#1072;&#1074;(&#1083;&#1072;):
    <blockquote cite="mid:4D89C704.5080603@orkash.com" type="cite">
      <meta content="text/html; charset=ISO-8859-1"
        http-equiv="Content-Type">
      I just want to retrieve that id 's from page_content which do not
      have
      any entry in clause2 table.<br>
      <br>
    </blockquote>
    Then <br>
    select distinct(p.crawled_page_id) from page_content p<br>
    &nbsp;where NOT EXISTS (select 1 from&nbsp; clause2 c where c.source_id =
    p.crawled_page_id);<br>
    is correct query.<br>
    <br>
    Best regards, Vitalii Tymchyshyn.<br>
  </body>
</html>

--------------030505040508020407020305--