On 9/21/07, Ottavio Campana <ottavio@xxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
