> > Maybe a suitable replacement for full-page would be to sync the
> > 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.


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to