Re: What is xmin ?

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: What is xmin ?
Date: 2005-01-18 18:16:55
Message-ID: m38y6q38mg.fsf@knuth.knuth.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In an attempt to throw the authorities off his trail, antonypaul24(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Witney 2005-01-18 18:23:23 Backup strategy
Previous Message alexandre::aldeia digital 2005-01-18 17:36:37 Re: Error al Subir base de datos