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

Reply via email to