Re: [GENERAL] Upgrade to dual processor machine? - Mailing list pgsql-performance

From Doug McNaught
Subject Re: [GENERAL] Upgrade to dual processor machine?
Date
Msg-id m3n0ocosfb.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Re: [GENERAL] Upgrade to dual processor machine?  ("Henrik Steffen" <steffen@city-map.de>)
Responses Re: [GENERAL] Upgrade to dual processor machine?
List pgsql-performance
"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

pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Docs about buffers and sortmem setting
Next
From: "Henrik Steffen"
Date:
Subject: Re: [GENERAL] Upgrade to dual processor machine?