> > We have noticed this line in our server log: > > Redo record at (5, 4209179252); Undo record at (0, 0); Shutdown TRUE > > > That second number seems awfully high; should this give us cause for > > concern? > > Looks fishy to me too --- the offset shouldn't exceed 24 bits AFAIR. > Vadim, what do you think?
Log record ptr is 4 bytes for log file ID and 4 bytes for record offset. # of segmets in log file (2^32 - 1) / 2^24 = 255 Max offset *in segment* is 2^24 , but max offset *in log file* is 255 * 2^24 = 4278190080 Vadim ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
