Re: Occasional giant spikes in CPU load

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: David Rees <drees76(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Occasional giant spikes in CPU load
Date: 2010-04-08 00:47:18
Message-ID: r2q603c8f071004071747n3e56d12bo11c49885b8c2eb2e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Apr 7, 2010 at 6:56 PM, David Rees <drees76(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Craig James 2010-04-08 02:06:15 Re: Occasional giant spikes in CPU load
Previous Message Tom Lane 2010-04-08 00:18:51 Re: Occasional giant spikes in CPU load