Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M277620=pgsql-hackers-arkari@postgresql.org>)
 id 1ZHdLn-0007fZ-RZ
 for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Jul 2015 19:37:15 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-hackers-owner+M277620=pgsql-hackers-arkari@postgresql.org>)
 id 1ZHdLn-0000oX-Di
 for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Jul 2015 19:37:15 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <kleptog@svana.org>) id 1ZHdLm-0000mv-DX
 for pgsql-hackers@postgresql.org; Tue, 21 Jul 2015 19:37:14 +0000
Received: from bilbys.org ([2400:c400::113:212:99:188] helo=svana.org)
 by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.84) (envelope-from <kleptog@svana.org>) id 1ZHdLh-0001ZZ-9V
 for pgsql-hackers@postgresql.org; Tue, 21 Jul 2015 19:37:13 +0000
Received: from kleptog by svana.org with local (Exim 4.72)
 (envelope-from <kleptog@svana.org>)
 id 1ZHdMD-0008B9-HJ; Wed, 22 Jul 2015 05:37:43 +1000
Date: Tue, 21 Jul 2015 21:37:41 +0200
From: Martijn van Oosterhout <kleptog@svana.org>
To: "Todd A. Cook" <tcook@blackducksoftware.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Andres Freund <andres@anarazel.de>,
 Fujii Masao <masao.fujii@gmail.com>,
 PostgreSQL-development <pgsql-hackers@postgresql.org>
Message-ID: <20150721193741.GC30213@svana.org>
Reply-To: Martijn van Oosterhout <kleptog@svana.org>
References: <20150703164931.GI3291@awork2.anarazel.de>
 <20150703170229.GJ3291@awork2.anarazel.de>
 <20150703172605.GM3291@awork2.anarazel.de>
 <CAHGQGwGGM2OBh4WOTd8wWqxKzRy+WdJX+-fxxPCWNz4eeJ1aQQ@mail.gmail.com>
 <27532.1436195680@sss.pgh.pa.us>
 <20150706152123.GK8902@alap3.anarazel.de>
 <28415.1436197794@sss.pgh.pa.us>
 <20150709182315.GG10242@alap3.anarazel.de>
 <29916.1436483171@sss.pgh.pa.us>
 <55AE8E6F.7030504@blackducksoftware.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature"; boundary="9amGYk9869ThD9tj"
Content-Disposition: inline
In-Reply-To: <55AE8E6F.7030504@blackducksoftware.com>
X-PGP-Key-ID: Length=4096; ID=0x4BE62D44
X-PGP-Key-Fingerprint: AF6F C0D6 3B8A AF7D 942B  D2BC 4BED FBE7 4BE6 2D44
User-Agent: Mutt/1.5.20 (2009-06-14)
X-SA-Exim-Connect-IP: <locally generated>
X-SA-Exim-Mail-From: kleptog@svana.org
X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on calyx
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00,NO_RELAYS
 autolearn=ham version=3.3.2
Subject: Re: WAL logging problem in 9.4.3?
X-SA-Exim-Version: 4.2.1 (built Mon, 22 Mar 2010 06:26:47 +0000)
X-SA-Exim-Scanned: Yes (on svana.org)
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-hackers>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-hackers.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@postgresql.org>
List-Post: <mailto:pgsql-hackers@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-hackers>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
X-Mailing-List: pgsql-hackers
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org


--9amGYk9869ThD9tj
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Tue, Jul 21, 2015 at 02:24:47PM -0400, Todd A. Cook wrote:
> Hi,
>=20
> This thread seemed to trail off without a resolution.  Was anything done?

Not that I can tell. I was the original poster of this thread. We've
worked around the issue by placing a CHECKPOINT command at the end of
the migration script.  For us it's not a performance issue, more a
correctness one, tables were empty when they shouldn't have been.

I'm hoping a fix will appear in the 9.5 release, since we're intending
to release with that version.  A forced checkpoint every now and them
probably won't be a serious problem though.

Have a nice day,
--=20
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> He who writes carelessly confesses thereby at the very outset that he does
> not attach much importance to his own thoughts.
   -- Arthur Schopenhauer

--9amGYk9869ThD9tj
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)

iQIVAwUBVa6fhEvt++dL5i1EAQiRJhAAvrC5NvDEateAIIUdHTfidvYQCrB5MHNS
8WBvv7jz8eYQ3Hye/lPUF5EsgF7UubthPoG0zwDO3oevCbohlmpYXqSMnqVyspVK
xknrmVWrwDXHnPO6ffn4WbOLWQ8PKEQHW21Bi9DdgCO3NNQKSnMLrUgquRjYlHPi
WOmp3uBtJvfuS3aJX88dpi1f3PWkBHFnNi1/j8KzjQ26BkA/A8BQ/YSs4CzM00yY
cvIJV+8hHndmA8sijPK0FQE5jYwj3n0OR+ICEkMi03ANHMFsLK+otv7+hgsIlIBA
Zgk/U/y+h79WjIH2NMuoHKa/KFQjyB2dksO724kz3rhpH7MvnnnMZZEgD4+++KKU
sFYfyGA7TNqugslricA+NQHzvVxbuflp7+HyFM54dnDNPsMEtCnaqWlEvNSmzUgj
WVsaPnfXgHfOOcVtENEBJFfrg1mRXjkiVMg6VfVPMsgssrSezT4TYfIfc995mv5y
TVjijly3dkd6df7yXZbL5EE9wlGoTC2KYU4Xwyyl+kMJ0YAzVPUQr+yGpr0IC5Y9
ENyirbzpEHDEFPBNf3uwSdaXOn8BGypa6cBSyQIkwDtKZqQ6q/zPVBWKvXuar/TD
8mXP3IyK94K7wlHwDb6tATQHg84ygKMYdDOMcAP2mi67fqP7klNTJ4sYHc94pLBH
Ne+SNwVF+kU=
=QfDa
-----END PGP SIGNATURE-----

--9amGYk9869ThD9tj--