Re: [GENERAL] Upgrade to dual processor machine?

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: [GENERAL] Upgrade to dual processor machine?
Дата
Msg-id m3n0ocosfb.fsf@varsoon.wireboard.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Upgrade to dual processor machine?  ("Henrik Steffen" <steffen@city-map.de>)
Ответы Re: [GENERAL] Upgrade to dual processor machine?  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список 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 по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: Docs about buffers and sortmem setting
Следующее
От: "Henrik Steffen"
Дата:
Сообщение: Re: [GENERAL] Upgrade to dual processor machine?