Deletes are slow in one table with many indices and FK references. That's not surprising, but it's VERY slow, and I'm trying to figure out why.
Is there any EXPLAIN option which shows what "query plans" Pg is using when checking FK references (index scan, seq scan, etc) during deletes (and inserts and updates)?
--
Born in Arizona, moved to Babylonia.
Born in Arizona, moved to Babylonia.