Tuning for PostGreSQL Database
Jim C. Nasby
jim at nasby.net
Mon Jul 21 12:26:50 PDT 2003
On Mon, Jul 21, 2003 at 05:06:47AM -0700, Jason Stone wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> On Sat, 19 Jul 2003, Tom Samplonius wrote:
> > Softupdates on, async off. Softupdates is just a better async.
> postgresql fsync's all its files before returning from a commit in order
> to ensure durability, right? Does softupdates interfere with the
> functioning of sync(2)/fsync(2)?
No, afaik it only fsync's the write-ahead-logs.
Jim C. Nasby, Database Consultant jim at nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
More information about the freebsd-performance