Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M51951=pgsql-performance-ar@postgresql.org>)
 id 1X89uE-0000Gi-UK
 for pgsql-performance@arkaria.postgresql.org; Fri, 18 Jul 2014 15:17:07 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M51951=pgsql-performance-ar@postgresql.org>)
 id 1X89uE-0008Cl-Ae
 for pgsql-performance@arkaria.postgresql.org; Fri, 18 Jul 2014 15:17:06 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <gc@mnc.ch>) id 1X89uC-0008A1-Qo
 for pgsql-performance@postgresql.org; Fri, 18 Jul 2014 15:17:04 +0000
Received: from 62-2-77-205.static.cablecom.ch ([62.2.77.205] helo=mail.op.lan)
 by makus.postgresql.org with esmtps
 (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80)
 (envelope-from <gc@mnc.ch>) id 1X89u8-0007gJ-2e
 for pgsql-performance@postgresql.org; Fri, 18 Jul 2014 15:17:02 +0000
Received: from localhost (localhost [127.0.0.1])
 by mail.op.lan (Postfix) with ESMTP id 3D169187FFC;
 Fri, 18 Jul 2014 17:16:55 +0200 (CEST)
X-Virus-Scanned: amavisd-new at example.com
Received: from mail.op.lan ([127.0.0.1])
 by localhost (mail.op.lan [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id zQDFRnOw7G8h; Fri, 18 Jul 2014 17:16:55 +0200 (CEST)
Received: from gc.localdomain (62-2-77-204.static.cablecom.ch [62.2.77.204])
 by mail.op.lan (Postfix) with ESMTP id 0A369187FE3;
 Fri, 18 Jul 2014 17:16:55 +0200 (CEST)
Received: by gc.localdomain (Postfix, from userid 500)
 id ABEFA18A4E8; Fri, 18 Jul 2014 17:16:54 +0200 (CEST)
To: Benjamin Dugast <bdugast@excilys.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Blocking every 20 sec while mass copying.
References: 
 <CAB9ggRqtNUngxJjAeD=ZLhkzw5OgkkqVBXkjMXC5j_9V50w-WQ@mail.gmail.com>
From: Guillaume Cottenceau <gc@mnc.ch>
X-Hashcash: 
 1:21:140718:bdugast@excilys.com::O9U/kXkCpzKqIO5h:0000000000000000000000000000000000000000003igE
X-Hashcash: 
 1:21:140718:pgsql-performance@postgresql.org::h+mUTndDoUW27Wdd:000000000000000000000000000001DB0
Date: Fri, 18 Jul 2014 17:16:54 +0200
In-Reply-To: 
 <CAB9ggRqtNUngxJjAeD=ZLhkzw5OgkkqVBXkjMXC5j_9V50w-WQ@mail.gmail.com>
 (Benjamin Dugast's message of "Fri\, 18 Jul 2014 12\:52\:39 +0200")
Message-ID: <m3tx6eg0ih.fsf@mnc.ch>
User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.3 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
X-Pg-Spam-Score: 1.7 (+)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Benjamin Dugast <bdugast 'at' excilys.com> writes:

>   =E2=80=A2 fsync to off (that helped but we can't do this)

not exactly your question, but maybe synchronous_commit=3Doff is a
nice enough intermediary solution for you (it may give better
performances at other places too for only an affordable cost)

--=20
Guillaume Cottenceau


--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance