When we do a PITR recovery based on xid, does it stop recovery based on the start of the xid or the commit of the xid? And if you say recovery_target_inclusive =true, does it recover that xid while not recoverying other xids that are higher but committed sooner than the target xid?
--------------------------------------------------------------------------- Oliver Elphick wrote: > On Wed, 2004-08-04 at 19:16, Tom Lane wrote: > > Oliver Elphick <[EMAIL PROTECTED]> writes: > > > How about adding a logging option to put the transaction id on the log > > > for every statement that modifies the database? Would that be a small > > > enough change to be allowed into 8.0? > > > > I think we could get away with adding transaction ID as one of the > > available %-items in log_line_prefix. I'm not sure how useful this > > really is though --- timestamps are probably more useful overall to > > have in your log. > > Why not both? > > You seem to be suggesting that using the id is less useful than the > time, but surely it's going to be easier to say "this disaster happened > in transaction 123 so lets do a PITR up to 122" than to say "this > happened at time x so do PITR up to x - 1 second"; the latter might miss > several tranactions. Have I got the concepts wrong here? > > > The direction I was expecting we'd head in is to > > provide WAL logfile examination tools. > > But that's not going to happen for 8.0, so any means of getting the > transaction id is better than none. > > -- > Oliver Elphick [EMAIL PROTECTED] > Isle of Wight http://www.lfix.co.uk/oliver > GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA > ======================================== > "And not only so, but we glory in tribulations also; > knowing that tribulation worketh patience; And > patience, experience; and experience, hope." > Romans 5:3,4 > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(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