Re: What is xmin ? - Mailing list pgsql-general

From Christopher Browne
Subject Re: What is xmin ?
Date
Msg-id m38y6q38mg.fsf@knuth.knuth.cbbrowne.com
Whole thread Raw
In response to What is xmin ?  (Antony Paul <antonypaul24@gmail.com>)
Responses Re: What is xmin ?
List pgsql-general
In an attempt to throw the authorities off his trail, antonypaul24@gmail.com (Antony Paul) transmitted:
>     I read about xmin in a thread on optimistic concurrency control.
> Can you guys tell me how to interpret this value. I want to convert
> this to date format. Is it possible ?

xmin is a transaction ID number.  There is no such conversion
possible.

http://www.faqs.org/docs/ppbook/x4636.htm

It would be kind of neat if there were some table into which
transactions were logged; in that case, there would presumably be a
couple of timestamps, namely the time at which the transaction began
and the time at which the transaction ended.  There is no such table
by default.
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org').
http://www.ntlug.org/~cbbrowne/languages.html
We are in fact well and truly doomed.
-- Jamie Zawinski http://www.jwz.org/gruntle/nscpdorm.html

pgsql-general by date:

Previous
From: Chris
Date:
Subject: DBD::Pg behavior for large queries
Next
From: Matthew Metnetsky
Date:
Subject: Re: Statically linking against libpq