> Check if it is using indexes. > 7.3 seems to ignore them somethimes, try upgrading to 7.4 where index use > is apparently improved.
good, i will upgrade anyway but how can i check index usage when DELETE from table1; ? EXPLAIN tells me only "seq scan on table1" when many other tables involved in this DELETE by foreign keys ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
