Re: [GENERAL] Upgrade to dual processor machine?

"Henrik Steffen" <steffen@city-map.de> writes:

> hi steve,
>
> why fsync? - what's fsync? never heard of it... google tells
> me something about syncing of remote hosts ... so why should I
> activate it ?? ... I conclude, it's probably disabled because
> I don't know what it is ....

fsync() is a system call that flushes a file's contents from the
buffer cache to disk.  PG uses it to ensure consistency in the WAL
files.  It is enabled by default.  Do NOT disable it unless you know
exactly what you are doing and are prepared to sacrifice some data
integrity for performance.

-Doug