Re: Postgres becoming slow, only full vacuum fixes it - Mailing list pgsql-performance

From Julien Cigar
Subject Re: Postgres becoming slow, only full vacuum fixes it
Date
Msg-id 506057E7.5090008@ulb.ac.be
Whole thread Raw
In response to Re: Postgres becoming slow, only full vacuum fixes it  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Postgres becoming slow, only full vacuum fixes it  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-performance
On 09/24/2012 14:34, Andres Freund wrote:
> On Monday, September 24, 2012 02:21:09 PM Julien Cigar wrote:
>> 5) synchronous_commit = off should only be used if you have a
>> battery-backed write cache.
> Huh? Are you possibly confusing this with full_page_writes?

indeed...! sorry for that
(note that you still have a (very) small chance of loosing data with
synchronous_commit = off if your server crashes between two "commit chunks")

> Greetings,
>
> Andres


--
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.


Attachment

pgsql-performance by date:

Previous
From: Andres Freund
Date:
Subject: Re: Postgres becoming slow, only full vacuum fixes it
Next
From: Andres Freund
Date:
Subject: Re: Postgres becoming slow, only full vacuum fixes it