Re: Transaction start in pg_stat_activity

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, "Neil Conway" <neilc(at)samurai(dot)com>, "pgsql-patches" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Transaction start in pg_stat_activity
Date: 2006-11-20 16:46:15
Message-ID: 7559.1164041175@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

"Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> That's true, but you don't know which one is the snapshot timestamp.

You're assuming there is such a thing as "the" unique active snapshot,
an assumption I find highly dubious. In any case, the reasons for
wanting to know which transactions are old have to do with the behavior
of VACUUM, and that only pays attention to the age of the whole
transaction not any individual snapshots. So I still don't see the
point of cluttering pg_stat_activity with yet more columns.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gurjeet Singh 2006-11-20 16:50:47 Re: [GENERAL] Allowing SYSDATE to Work
Previous Message Simon Riggs 2006-11-20 16:41:43 Re: Transaction start in pg_stat_activity

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-11-20 19:09:41 Re: [PATCHES] WIP 2 interpreters for plperl
Previous Message Simon Riggs 2006-11-20 16:41:43 Re: Transaction start in pg_stat_activity