On Wed, 9 Oct 2002, Magnus Naeslund(f) wrote:
> Hello, i've got this query that's really slow... > Figure this: > > testdb=> select now() ; select gid from bs where gid not in ( select x > from z2test ); select now(); Per FAQ suggestion, try something like select gid from bs where not exists (select * from z2test where z2test.x=bs.gid); to see if it is faster. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
