Re: Exposing the Xact commit order to the user

Excerpts from Chris Browne's message of jue jun 03 16:21:35 -0400 2010:

> What this offers is *SOME* idea of how much updating work a particular
> transaction did.  It's a bit worse than you suggest:
> 
>  - If replication triggers have captured tuples, those would get
>    counted.
> 
>  - TOAST updates might lead to extra updates being counted.
> 
> But back to where you started, I'd anticipate 7 inserts, 7 deletes,
> and 7 updates being counted as something around 21 updates.
> 
> And if that included 5 TOAST changes, it might bump up to 26.
> 
> If there were replication triggers in place, that might bump the count
> up to 45 (which I chose arbitrarily).

Why not send separate numbers of tuple inserts/updates/deletes, which we
already have from pgstats?

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support