[SQL] Cascade delete question

Hi All, I am using a cascade delete on the following table: vidvnameparentname 1 [EMAIL PROTECTED] 2 [EMAIL PROTECTED] [EMAIL PROTECTED] 3 [EMAIL PROTECTED] [EMAIL PROTECTED] 4 [EMAIL PROTECTED] [EMAIL PROTECTED] 5 [EMAIL PROTECTED] [E

Re: [SQL] cascade delete

> 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

[SQL] cascade delete

hi why a cascade delete is so slow ? pgsql 7.3.3 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the m