> > 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
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.
In response to
pgsql-hackers by date
|Next:||From: Zeugswetter Andreas ADI SD||Date: 2007-03-01 13:28:17|
|Subject: Re: Resumable vacuum proposal and design overview|
|Previous:||From: Simon Riggs||Date: 2007-03-01 13:14:14|
|Subject: Re: Revitalising VACUUM FULL for 8.3|