Re: Re-Reason of Slowness of Query

From: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
To: Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Re-Reason of Slowness of Query
Date: 2011-03-23 10:10:12
Message-ID: 4D89C704.5080603@orkash.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I just want to retrieve that id 's from page_content which do not have
any entry in clause2 table.

Thanks , Adarsh

Vitalii Tymchyshyn wrote:
> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vitalii Tymchyshyn 2011-03-23 10:12:08 Re: Re-Reason of Slowness of Query
Previous Message Vitalii Tymchyshyn 2011-03-23 09:26:46 Re: Re-Reason of Slowness of Query