pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedcascade delete
2+ messages / 1 participants
[nested] [flat]
* cascade delete
@ 2004-02-12 07:33 sad <sad@bankir.ru>
2004-02-12 08:45 ` Re: cascade delete sad <sad@bankir.ru>
0 siblings, 1 reply; 2+ messages in thread
From: sad @ 2004-02-12 07:33 UTC (permalink / raw)
To: pgsql-sql
hi
why a cascade delete is so slow ?
pgsql 7.3.3
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: cascade delete
2004-02-12 07:33 cascade delete sad <sad@bankir.ru>
@ 2004-02-12 08:45 ` sad <sad@bankir.ru>
0 siblings, 0 replies; 2+ messages in thread
From: sad @ 2004-02-12 08:45 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-02-12 08:45 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-12 07:33 cascade delete sad <sad@bankir.ru>
2004-02-12 08:45 ` sad <sad@bankir.ru>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox