> It's already possible to set fsync=off on the standby if you want. If
> there is an OS-level crash you'll need to rebuild the standby, but in
> some cases that may be acceptable.
Yes, generally if there's an OS-level crash on cloud hosting, you've
lost the instance anyway.
> And Simon has already written a patch to add a "receive" mode to sync
> rep, which I expected will get committed to 9.2. In that mode, the
> standby can acknowledge the WAL records as soon as they are received,
> and write them to disk just after. I think we do need some
> benchmarking there, to figure out whether any changes to the timing of
> replies are needed in that case. But the basic principal seems sound.
Yes, that's what I'm looking for. The one other thing would be the
ability not to fsync the master, which would come out of the whole
"stream from buffers" patch which Fujii was working on. Fujii, is that
still something you're working on?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com