Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA13820 for ; Tue, 27 Jul 1999 09:38:51 -0400 (EDT) (envelope-from predragl@cg.yu) Received: from cg.yu (mail.cg.yu [195.66.161.254]) by trends.net (8.8.8/8.8.8) with ESMTP id FAA01700 for ; Tue, 27 Jul 1999 05:21:07 -0400 (EDT) Received: from cg.yu (IDENT:root@predrag.cg.yu [195.66.162.5]) by cg.yu (8.9.2/8.9.2) with ESMTP id LAA04338 for ; Tue, 27 Jul 1999 11:22:31 +0200 (MET DST) Sender: root@cg.yu Message-ID: <379D7A0E.C840D9C2@cg.yu> Date: Tue, 27 Jul 1999 11:21:19 +0200 From: Predrag Lesic X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.5-15 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: SELECT .. WHERE field IN (SELECT .. ) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I have problem with next query SELECT COUNT(*) FROM TABLE1 WHERE field1 IN (SELECT DISTINCT field2 FROM TABLE2 WHERE field3>'some date') Processing time of the query is toooooooooo long. I didn't get the answer. Postgres is doing something, I can see disk is working for some time, and the query is running. But how long????? Thank's Predrag