Postgres Pro
Downloads
Home   >   mailing lists

Re: Re-Reason of Slowness of Query - Mailing list pgsql-performance

From Vitalii Tymchyshyn
Subject Re: Re-Reason of Slowness of Query
Date
Msg-id 4D89C778.6050805@gmail.com
Whole thread Raw
In response to Re: Re-Reason of Slowness of Query  (Adarsh Sharma <adarsh.sharma@orkash.com>)
Responses Re: Re-Reason of Slowness of Query
List pgsql-performance
Tree view
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.

pgsql-performance by date:

Previous
From: Adarsh Sharma
Date:
Subject: Re: Re-Reason of Slowness of Query
Next
From: Adarsh Sharma
Date:
Subject: Re: Re-Reason of Slowness of Query