Notes

• Seedling· Just planted. May be wrong.
• Budding· Checked once; the structure holds.
• Evergreen· I would defend this. Revisited at least once.

The notes that define a term are gathered, one line each, in the glossary.

• Full-page writes and torn pages

  2026-09-22note · evergreen

  Why the first change to a page after a checkpoint carries the whole 8 KB page in WAL.

  #postgresql #databases

• Lazy transaction id assignment

  2026-09-22note · seedling

  A transaction does not get an xid at BEGIN; it gets one the first time it writes.

  #postgresql

• pd_lsn vs record LSN

  2026-09-21note · budding

  Two LSNs that are easy to mix up, and the rule recovery uses to compare them.

  #postgresql

(3 rows)