Re: Occasional giant spikes in CPU load

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Occasional giant spikes in CPU load
Дата
Msg-id r2q603c8f071004071747n3e56d12bo11c49885b8c2eb2e@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Occasional giant spikes in CPU load  (David Rees <drees76@gmail.com>)
Ответы Re: Occasional giant spikes in CPU load  (Craig James <craig_james@emolecules.com>)
Список pgsql-performance
On Wed, Apr 7, 2010 at 6:56 PM, David Rees <drees76@gmail.com> wrote:
>> max_fsm_pages = 16000000
>> max_fsm_relations = 625000
>> synchronous_commit = off
>
> You are playing with fire here.  You should never turn this off unless
> you do not care if your data becomes irrecoverably corrupted.

That is not correct.  Turning off synchronous_commit is sensible if
you don't mind losing the last few transactions on a crash.  What will
corrupt your database is if you turn off fsync.

...Robert

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Occasional giant spikes in CPU load
Следующее
От: Craig James
Дата:
Сообщение: Re: Occasional giant spikes in CPU load