Re: [GENERAL] Upgrade to dual processor machine?

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: [GENERAL] Upgrade to dual processor machine?
Дата
Msg-id Pine.LNX.4.33.0211141257410.1942-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Upgrade to dual processor machine?  (Doug McNaught <doug@mcnaught.org>)
Ответы Re: [GENERAL] Upgrade to dual processor machine?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On 14 Nov 2002, Doug McNaught wrote:

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

I thought the danger with WAL was minimized to the point of not being an
issue anymore.  Tom?


В списке pgsql-performance по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: [GENERAL] Upgrade to dual processor machine?
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: Sort time