From: Julien Cigar <jcigar@ulb.ac.be>
To: Andres Freund <andres@2ndquadrant.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres becoming slow, only full vacuum fixes it
Date: Mon, 24 Sep 2012 14:53:59 +0200
Message-ID: <506057E7.5090008@ulb.ac.be> (raw)
In-Reply-To: <201209241434.56760.andres@2ndquadrant.com>
References: <D15ECA12-8D6E-4E53-A294-5E175564CA61@gmail.com>
<71DC95CE-16EF-4D53-9971-C573DCD30622@gmail.com>
<50605035.8020107@ulb.ac.be>
<201209241434.56760.andres@2ndquadrant.com>
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.
Attachments:jcigar.vcf (text/x-vcard, 290B) download
begin:vcard
fn:Julien Cigar
n:Cigar;Julien
org;quoted-printable:Belgian Biodiversity Platform;ULB (Universit=C3=A9 Libre de Bruxelles)
adr:;;;Brussels;;;Belgium
email;internet:jcigar@ulb.ac.be
tel;work:+32(0)26505752
x-mozilla-html:FALSE
url:http://www.biodiversity.be
version:2.1
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jcigar@ulb.ac.be, andres@2ndquadrant.com
Subject: Re: Postgres becoming slow, only full vacuum fixes it
In-Reply-To: <506057E7.5090008@ulb.ac.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox