SELECT statement never completes.

From: John Pauley <karstdiver(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: SELECT statement never completes.
Date: 2002-10-09 17:10:21
Message-ID: 20021009171021.25211.qmail@web13408.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

pgsql-sql,

We are porting a database from IBM DB2 to PostgreSQL.
In several related scripts, there is a SELECT
statement that never completes in Postgres but
completes in a few seconds using DB2, for example:

Table row count:
SELECT count(*) FROM tableX;
112671
SELECT count(*) from tableY;
314625

This statement does not complete:
SELECT id FROM tableX WHERE id NOT IN (SELECT id FROM
tableY);

Any suggestions?
Thanks

__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-10-09 17:26:31 Re: SELECT statement never completes.
Previous Message Jose Antonio Leo 2002-10-09 16:56:41 problem with the Index