Re: transction_timestamp() inside of procedures - Mailing list pgsql-hackers

From Andres Freund
Subject Re: transction_timestamp() inside of procedures
Date
Msg-id 20181002144901.mft2wjuwqujryx4p@alap3.anarazel.de
Whole thread Raw
In response to Re: transction_timestamp() inside of procedures  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Hi,

On 2018-10-02 10:55:56 +0200, Peter Eisentraut wrote:
> On 28/09/2018 09:35, Peter Eisentraut wrote:
> >> That's certainly a good argument.  Note that if we implemented that the
> >> transaction timestamp is advanced inside procedures, that would also
> >> mean that the transaction timestamp as observed in pg_stat_activity
> >> would move during VACUUM, for example.  That might or might not be
> >> desirable.
> > 
> > Attached is a rough implementation.
> > 
> > I'd be mildly in favor of doing this, but we have mentioned tradeoffs in
> > this thread.
> 
> So do we want to do this or not?

Without having reviewed the patch yet, yes, I'd say we want this.

Greetings,

Andres Freund


pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: [HACKERS] Re: Improve OR conditions on joined columns (commonstar schema problem)
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re: Improve OR conditions on joined columns (common star schema problem)