On Tue, 6 Jul 2004, Zeugswetter Andreas SB SD wrote: > > Should we use a different datatype than time_t for the commit timestamp, > > one that offers more fine grained differentiation between checkpoints? > > Imho seconds is really sufficient. If you know a more precise position > you will probably know it from backend log or an xlog sniffer. With those > you can easily use the TransactionId way.
I'd also think that seconds are absolutely sufficient. From my daily experience I can say that you're normally lucky to know the time on one minute basis. If you need to get closer, a log sniffer is unavoidable ... Greetings, Klaus -- Full Name : Klaus Naumann | (http://www.mgnet.de/) (Germany) Phone / FAX : ++49/177/7862964 | E-Mail: ([EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match