Re: [GENERAL] Slow delete with with cascading foreign keys

Matthias Karlsson <[EMAIL PROTECTED]> writes: > Tom Lane skrev: >> If it's a reasonably modern PG version, EXPLAIN ANALYZE will break out >> the time spent in each on-delete trigger, which should be enough to >> answer the question. > Thanks, that gave me something to work with. I targeted the tri

Re: [GENERAL] Slow delete with with cascading foreign keys

Tom Lane skrev: "Matthias Karlsson" <[EMAIL PROTECTED]> writes: I have a rather complex set of relations, connected with cascading foreign keys on delete. I'm experiencing very slow performance when deleting *the* lead node, which everything eventually depends on. The number of records ultimatel

Re: [GENERAL] Slow delete with with cascading foreign keys

"Matthias Karlsson" <[EMAIL PROTECTED]> writes: > I have a rather complex set of relations, connected with cascading > foreign keys on delete. I'm experiencing very slow performance when > deleting *the* lead node, which everything eventually depends on. The > number of records ultimately to be del

[GENERAL] Slow delete with with cascading foreign keys

Hi, I have a rather complex set of relations, connected with cascading foreign keys on delete. I'm experiencing very slow performance when deleting *the* lead node, which everything eventually depends on. The number of records ultimately to be deleted aren't that many (perhaps 2000-3000) but there