Received: from malur.postgresql.org ([2a02:16a8:dc51::56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1fueKC-0001JR-1o
	for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 13:46:28 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1fueK9-0000CI-Li
	for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 13:46:25 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <066ce286@free.fr>)
	id 1fueJu-0007QI-At
	for pgsql-admin@lists.postgresql.org; Tue, 28 Aug 2018 13:46:10 +0000
Received: from smtp1-g21.free.fr ([2a01:e0c:1:1599::10])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <066ce286@free.fr>)
	id 1fueJq-0006rp-A1
	for pgsql-admin@lists.postgresql.org; Tue, 28 Aug 2018 13:46:08 +0000
Received: from zimbra82-e14.priv.proxad.net (unknown [172.20.243.235])
	by smtp1-g21.free.fr (Postfix) with ESMTP id 617AEB0055A;
	Tue, 28 Aug 2018 15:46:03 +0200 (CEST)
Date: Tue, 28 Aug 2018 15:46:02 +0200 (CEST)
From: 066ce286@free.fr
To: wambacher@posteo.de
Cc: pgsql-admin@lists.postgresql.org
Message-ID: 
 <1495817175.367327613.1535463961983.JavaMail.root@zimbra82-e14.priv.proxad.net>
In-Reply-To: <84c2baff-89e3-931f-232a-f6ca832eb364@posteo.de>
Subject: Re: tuple concurrently updated
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
X-Originating-IP: [2a01:e35:2434:2250:8c8e:8d27:9c28:8ea3]
X-Mailer: Zimbra 7.2.0-GA2598 (ZimbraWebClient - GC68 (Linux)/7.2.0-GA2598)
X-Authenticated-User: 066ce286@free.fr
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

AAMOF, what are your fsync/wal_sync_method parameters, and what is your sto=
rage hardware ?

----- Mail original -----
De: wambacher@posteo.de
=C3=80: pgsql-admin@lists.postgresql.org
Envoy=C3=A9: Mardi 28 Ao=C3=BBt 2018 15:38:37
Objet: Re: tuple concurrently updated

so do i :( but i will try it.

in parall the preperations for a full import are running. e.g the
download will need 2 hours.

walter


Am 28.08.2018 um 15:34 schrieb 066ce286@free.fr:
> I don't think a vacuum can handle what a pg_dump can't. But I'm maybe wro=
ng.
>