Kevin Grittner escribió: > [I'm replying to Robert's message only because it is the latest on > the thread; I'm actually kinda replying to the whole thread in > general.]
Thanks for the great summary. > (4) Subsequent discussion has produced a few shadowy hints at what > such uses look like, with the most concrete being a one-time load of > partitions, for which rules are apparently one or two orders of > magnitude faster than FOR EACH ROW truggers. There was also a mention > of writing to a log table being easier. Out of 100+ messages on this > thread, I can't recall anything else that wasn't pretty vague. I think enabling OLD/NEW in FOR EACH STATEMENT triggers would go a long way. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers