Re: XLog: how to log? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: XLog: how to log?
Date
Msg-id 200405112209.i4BM9po09799@candle.pha.pa.us
Whole thread Raw
In response to Re: XLog: how to log?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: XLog: how to log?
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Many transactions are going to have the same timestamp because that just
> > isn't precise enough to choose a particular transaction.
> 
> I think this argument is largely a red herring ... but if it makes you
> feel better, we could change the contents of the commit timestamp to
> be gettimeofday() output (seconds+microseconds) instead of just time()
> output.  That should be precise enough for practical purposes.

I am saying timestamp as used for specifying a recovery location might
not be unique enough, no?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: XLog: how to log?
Next
From: Bruce Momjian
Date:
Subject: Re: Probably security hole in postgresql-7.4.1