Tuning for PostGreSQL Database

[Jim C. Nasby]

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?"