Re: Select Statement Hang... - Mailing list pgsql-novice

From Chad Thompson
Subject Re: Select Statement Hang...
Date
Msg-id 005001c34fb2$6674a7c0$32021aac@chad
Whole thread Raw
In response to Select Statement Hang...  (ttzhang <ttzhang@uclink.berkeley.edu>)
List pgsql-novice



> I was trying to set up a foreign key for an id field but found out that
some
> of the ids are not in the referenced table.  To look things up, I tried
>
> select id from btable where id not in (select id from atable)
>
> The query just hang.....  My tables are pretty big (200, 000?)  can anyone
> help me to pinpoint the problem?
>
> Thanks!
>

You might try

select id
from btable
where not exists
(select id from atable)

I have found that this performs better.
You should also make sure that you've vacuumed your tables.

If this doesnt help, post the results of

explain analyze
select id
from btable
where not exists
(select id from atable)

HTH
Chad


pgsql-novice by date:

Previous
From: Dmitry Tkach
Date:
Subject: Re: Locking tables
Next
From: Bruce Momjian
Date:
Subject: Re: Where do I get LIBPQEASY?