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