Re: xact_start meaning when dealing with procedures?

2018-08-15 Thread Michael Paquier
On Wed, Aug 15, 2018 at 06:23:40PM -0400, Jonathan S. Katz wrote: > This was added as an open item by Michael[1]. When the RMT discussed, > we were able to make arguments both ways (i.e. adjusting the behavior vs. > not). > > Peter, from your analysis it sounds like we should leave it, but I

Re: xact_start meaning when dealing with procedures?

2018-08-15 Thread Jonathan S. Katz
> On Aug 10, 2018, at 4:39 AM, Peter Eisentraut > wrote: > > On 09/08/2018 20:25, Vik Fearing wrote: >> On 09/08/18 20:13, Peter Eisentraut wrote: >>> On 09/08/2018 19:57, hubert depesz lubaczewski wrote: I just noticed that when I called a procedure that commits and rollbacks - the

Re: xact_start meaning when dealing with procedures?

2018-08-10 Thread Michael Paquier
On Thu, Aug 09, 2018 at 07:49:31PM +0200, hubert depesz lubaczewski wrote: > I just noticed that when I called a procedure that commits and rollbacks > - the xact_start in pg_stat_activity is not updated. Is it intentional? > > I'm on newest 12devel, built today. That sounds incorrect to me. I

Re: xact_start meaning when dealing with procedures?

2018-08-10 Thread Peter Eisentraut
On 09/08/2018 20:25, Vik Fearing wrote: > On 09/08/18 20:13, Peter Eisentraut wrote: >> On 09/08/2018 19:57, hubert depesz lubaczewski wrote: >>> I just noticed that when I called a procedure that commits and rollbacks >>> - the xact_start in pg_stat_activity is not updated. Is it intentional? >>

Re: xact_start meaning when dealing with procedures?

2018-08-09 Thread Vik Fearing
On 09/08/18 20:13, Peter Eisentraut wrote: > On 09/08/2018 19:57, hubert depesz lubaczewski wrote: >> I just noticed that when I called a procedure that commits and rollbacks >> - the xact_start in pg_stat_activity is not updated. Is it intentional? > > It's an artifact of the way this is

Re: xact_start meaning when dealing with procedures?

2018-08-09 Thread Peter Eisentraut
On 09/08/2018 19:57, hubert depesz lubaczewski wrote: > I just noticed that when I called a procedure that commits and rollbacks > - the xact_start in pg_stat_activity is not updated. Is it intentional? It's an artifact of the way this is computed. The reported transaction timestamp is the