> > Maybe a suitable replacement for full-page would be to sync the first > > WAL record for a page change before writing the buffer > > We *always* sync WAL records for page changes before writing > the buffer for the page.
Um, is that so ? And how is that done ? (e.g. bgwriter would need to wait for or even initiate a WAL record sync) Seems this is not clear to others eighter. Why else would people think we need a full data scan after crash without full-pages ? If this is true, all pages with possibly pending IO during crash will be touched and could thus be checked during startup recovery. I can see that we need to sync wal before write for certain changes, but I don't see why we would currently need it for e.g. a heap insert, that gets a free slot. Andreas ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
