REDO record

WAL record written immediately after a checkpoint

A REDO record is a WAL record written immediately after a checkpoint, containing necessary information to carry out recovery from WAL.

Examples

REDO record displayed using pg_waldump:

rmgr: XLOG len (rec/tot): 106/ 106, tx: 0, lsn: 0/3B762D10, prev 0/3B762CD8, desc: CHECKPOINT_ONLINE redo 0/3B762CD8; tli 1; prev tli 1; fpw true; xid 0:2419; oid 27436; multi 1; offset 0; oldest xid 598 in DB 1; oldest multi 1 in DB 1; oldest/newest commit timestamp xid: 0/0; oldest running xid 2419; online 

Categories

PostgreSQL internals, WAL

See also

REDO WAL file