Matthias Karlsson <matthias@xxxxxxx> 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 triggers that had the most "uses", but it did not seem to > help that much. I managed to reduce execution time with maybe 10-15%, but I'll try to apply indices more aggressively to > see if it helps. Hm, you still didn't mention which PG version you're using --- but if it's pre-8.3, keep in mind that you need to start a fresh session to get the plans for FK triggers to change. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
