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:
> 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 mailing list