Re: transction_timestamp() inside of procedures
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <bruce@momjian.us>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>,
Michael Paquier <michael@paquier.xyz>,
Andres Freund <andres@anarazel.de>,
PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2018-09-26T14:07:03Z
Lists: pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes: > On Wed, Sep 26, 2018 at 02:38:25PM +0200, Peter Eisentraut wrote: >> We could certainly address this by adding three or four or five new >> timestamps that cover all these varieties. But perhaps it's worth >> asking what these timestamps are useful for and which ones we really need. > Frankly, we might be fine with just documenting it and see if anyone > complains. I'm not for adding a bunch of new action-start timestamps without very clear use-cases for them, because each one we add means more gettimeday() overhead that might or might not ever be useful. I agree that it would be surprising for transaction timestamp to be newer than statement timestamp. So for now at least, I'd be satisfied with documenting the behavior. regards, tom lane
Commits
-
Advance transaction timestamp for intra-procedure transactions.
- 82ff0cc91d98 12.0 landed
- 1145c26b749a 11.0 landed