Re: Postgres becoming slow, only full vacuum fixes it

On Monday, September 24, 2012 02:53:59 PM Julien Cigar wrote:
> 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")
Sure, you have a chance of loosing the last some transactions, but you won't
corrupt anything. Thats the entire point of the setting ;)

Greetings,

Andres
--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services