Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <andres@2ndquadrant.com>) id 1TG7sK-00057C-6R
	for pgsql-performance@postgresql.org; Mon, 24 Sep 2012 12:35:00 +0000
Received: from moutng.kundenserver.de ([212.227.17.9])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <andres@2ndquadrant.com>) id 1TG7sI-0002HS-RR
	for pgsql-performance@postgresql.org; Mon, 24 Sep 2012 12:34:59 +0000
Received: from awork2.localnet (p5DDC5657.dip.t-dialin.net [93.220.86.87])
	by mrelayeu.kundenserver.de (node=mrbap0) with ESMTP (Nemesis)
	id 0Lf0SV-1TpDIc3I2J-00qJEv; Mon, 24 Sep 2012 14:34:57 +0200
From: Andres Freund <andres@2ndquadrant.com>
Organization: 2ndquadrant.com
To: pgsql-performance@postgresql.org
Subject: Re: Postgres becoming slow, only full vacuum fixes it
Date: Mon, 24 Sep 2012 14:34:56 +0200
User-Agent: KMail/1.13.7 (Linux/3.6.0-rc6-andres-00066-g2682cc4-dirty;
	KDE/4.8.4; x86_64; ; )
Cc: Julien Cigar <jcigar@ulb.ac.be>
References: <D15ECA12-8D6E-4E53-A294-5E175564CA61@gmail.com>
	<71DC95CE-16EF-4D53-9971-C573DCD30622@gmail.com>
	<50605035.8020107@ulb.ac.be>
In-Reply-To: <50605035.8020107@ulb.ac.be>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
Message-Id: <201209241434.56760.andres@2ndquadrant.com>
X-Provags-ID: V02:K0:1mhqz/2lpjyI6V/dWMM9MnVme/h0PdTNOKJE7O78DLo
	ts8kgvFWdlWAXtn79a1k5MHvF9nnr4uZncjcP1Ycg7CzFBW140
	bp4sWNqBXRWPlfTjzwNU0Xx5RIo1F+ysoQ0efvrBu/mKf+50j2
	nzbAOuFTN+j73sNiBJQs4U3gSpOBOh2e4JdqPPs5hUGLu4Oo7V
	ZEwpuEDuNRZUQCp/uRht8wfenPHxtz1Dkhknn4ijzeN8nkQdtc
	01ShfbOLG0s1uNSp0kmT83izhw319eY0X8qJKUObQXU+9D0oGW
	j4Kez5nD1rpm64wa3BuUnSpneZ3RDGF/BwLl9Dt907xKQEv5jD
	sJjOKqEoCqXDLQA30BpJMzE06iTc2foeMmRas2cqw
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201209/107
X-Sequence-Number: 47853

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?

Greetings,

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