Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 456F21337BDA
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 23 Mar 2011 06:27:34 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 03015-02-5
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 23 Mar 2011 09:27:16 +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 0FEA61337BFC
	for <pgsql-performance@postgresql.org>;
	Wed, 23 Mar 2011 06:26:28 -0300 (ADT)
Received: by fxm17 with SMTP id 17so7152100fxm.19
	for <pgsql-performance@postgresql.org>;
	Wed, 23 Mar 2011 02:26:28 -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=8aWBsLUy8bz3G9PiqHlkjhrGa3zVfBDLY9PYiRVk7zY=;
	b=AfZ+pj9dhFJvwLDZeZ2hw9pdSxeXJ3H8J+a67VhN8zUXNej89kTWpPkQFEoREo13s9
	G3pPuk3NmorcdR76f982ftgwCfc+96uc0yeQdMtrwqQpGQtAU5Pkq7x8+zYpjPryhz7y
	JQEBvdemXtRFzT12YyFnKOYb79zBlhvzp3z3s=
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=xQ84k0QHDHw2JWUQFGAgxnYXZvLUOikxjA+Y41+CIQROL6ncMDK/EurRkvo7WwCKNr
	3SXBfzi6iCHEQsFgn4pTgjNO/XTo7Tv+8vBvIR4mizQqw8pI0J/Uz8lEZje+cRC1IlVD
	f908/NHe+kHKH4WEDUcI+tWgcPeQabIpgzFd0=
Received: by 10.223.98.8 with SMTP id o8mr2907307fan.22.1300872388103;
	Wed, 23 Mar 2011 02:26:28 -0700 (PDT)
Received: from [10.1.1.57] (skuns.zoral.com.ua [91.193.166.194])
	by mx.google.com with ESMTPS id k5sm825540faa.15.2011.03.23.02.26.26
	(version=TLSv1/SSLv3 cipher=OTHER);
	Wed, 23 Mar 2011 02:26:26 -0700 (PDT)
Message-ID: <4D89BCD6.6040604@gmail.com>
Date: Wed, 23 Mar 2011 11:26:46 +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>
In-Reply-To: <4D89BABF.4080806@orkash.com>
Content-Type: multipart/alternative;
	boundary="------------090600090006010808070406"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.045 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=1.553,
	FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_LOW=-0.7
X-Spam-Level: 
X-Archive-Number: 201103/261
X-Sequence-Number: 42940

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

23.03.11 11:17, Adarsh Sharma ???????(??):
>
> I think it is very much faster but I don't understand the query :
>
> *explain select distinct(b) from t1,t2 where t1.b >t2.d union all  
> select distinct(b) from t1,t2 where  t1.b <t2.d;
> *
I don't understand it too. What are you trying to get? Is it
select distinct(b) from t1 where  b > (select min(d) from t2)**or b < 
(select max(d) from t2)
?

Can you explain in words, not SQL, what do you expect do retrieve?

Best regards, Vitalii Tymchyshyn

--------------090600090006010808070406
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 11:17, Adarsh Sharma &#1085;&#1072;&#1087;&#1080;&#1089;&#1072;&#1074;(&#1083;&#1072;):
    <blockquote cite="mid:4D89BABF.4080806@orkash.com" type="cite">
      <br>
      I think it is very much faster but I don't understand the query :<br>
      <br>
      <b>explain select distinct(b) from t1,t2 where t1.b &gt;t2.d union
        all&nbsp;
        select distinct(b) from t1,t2 where&nbsp; t1.b &lt;t2.d;<br>
      </b><br>
    </blockquote>
    I don't understand it too. What are you trying to get? Is it <br>
    select distinct(b) from t1 where&nbsp; b &gt; (select min(d) from t2)<b>
    </b>or b&nbsp; &lt; (select max(d) from t2)<br>
    ?<br>
    <br>
    Can you explain in words, not SQL, what do you expect do retrieve?<br>
    <br>
    Best regards, Vitalii Tymchyshyn<br>
  </body>
</html>

--------------090600090006010808070406--