On 9/21/07, Ottavio Campana <ottavio@campana.vi.it> wrote:
> My problem is that if I run the same command on another
> table with 378415 rows, it is terribly slow.
How much is "terribly slow"?
Did you VACUUM ANALYZE?
Anyways, try this:
SELECT * FROM MYTABLE T1
LEFT JOIN COPY_MYTABLE T2
ON T1.ID = T2.ID
WHERE T2.ID IS NULL