| From: | Doug McNaught <doug(at)mcnaught(dot)org> |
|---|---|
| To: | "Henrik Steffen" <steffen(at)city-map(dot)de> |
| Cc: | "Steve Wolfe" <nw(at)codon(dot)com>, <pgsql-general(at)postgresql(dot)org>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Upgrade to dual processor machine? |
| Date: | 2002-11-14 19:35:52 |
| Message-ID: | m3n0ocosfb.fsf@varsoon.wireboard.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
"Henrik Steffen" <steffen(at)city-map(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henrik Steffen | 2002-11-14 19:36:28 | Re: Upgrade to dual processor machine? |
| Previous Message | Joe Tomcat | 2002-11-14 19:35:29 | Re: 1600 Column limit.. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henrik Steffen | 2002-11-14 19:36:28 | Re: Upgrade to dual processor machine? |
| Previous Message | scott.marlowe | 2002-11-14 19:27:42 | Re: Docs about buffers and sortmem setting |