Re: Index Scans become Seq Scans after VACUUM ANALYSE

J. R. Nield wrote:
> One other point:
> 
> Page pre-image logging is fundamentally the same as what Jim Grey's
> book[1] would call "careful writes". I don't believe they should be in
> the XLOG, because we never need to keep the pre-images after we're sure
> the buffer has made it to the disk. Instead, we should have the buffer
> IO routines implement ping-pong writes of some kind if we want
> protection from partial writes.

Ping-pong writes to where?  We have to fsync, and rather than fsync that
area and WAL, we just do WAL.  Not sure about a win there.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026