Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group