Re: Re-Reason of Slowness of Query

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

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Adarsh Sharma 2011-03-23 10:19:18 Re: Re-Reason of Slowness of Query
Previous Message Adarsh Sharma 2011-03-23 10:10:12 Re: Re-Reason of Slowness of Query