Re: cascade delete - Mailing list pgsql-sql

From sad
Subject Re: cascade delete
Date
Msg-id 200402121145.10845.sad@bankir.ru
Whole thread Raw
In response to cascade delete  (sad <sad@bankir.ru>)
List pgsql-sql
> 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




pgsql-sql by date:

Previous
From: sad
Date:
Subject: cascade delete
Next
From: "Kumar"
Date:
Subject: How to avoid nulls while writing string for dynamic query