pgsql: Perform less setup work for AFTER triggers at transaction start. - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Perform less setup work for AFTER triggers at transaction start.
Date
Msg-id E1XhLR9-0004NK-Fj@gemulon.postgresql.org
Whole thread Raw
Responses Re: pgsql: Perform less setup work for AFTER triggers at transaction start.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers
Perform less setup work for AFTER triggers at transaction start.

Testing reveals that the memory allocation we do at transaction start
has small but measurable overhead on simple transactions.  To cut
down on that overhead, defer some of that work to the point when
AFTER triggers are first used, thus avoiding it altogether if they
never are.

Patch by me.  Review by Andres Freund.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/2781b4bea7db357be59f9a5fd73ca1eb12ff5a79

Modified Files
--------------
src/backend/commands/trigger.c |  428 ++++++++++++++++++++++------------------
1 file changed, 232 insertions(+), 196 deletions(-)


pgsql-committers by date:

Previous
From: Fujii Masao
Date:
Subject: pgsql: Remove the unused argument of PSQLexec().
Next
From: Tom Lane
Date:
Subject: pgsql: Improve ispell dictionary's defenses against bad affix files.