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