pg.ddx.io pgsql-hackers@postgresql.org mailing list archive
help / color / mirror / Atom feedFrom: Martijn van Oosterhout <kleptog@svana.org>
To: Todd A. Cook <tcook@blackducksoftware.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andres Freund <andres@anarazel.de>
Cc: Fujii Masao <masao.fujii@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: WAL logging problem in 9.4.3?
Date: Tue, 21 Jul 2015 21:37:41 +0200
Message-ID: <20150721193741.GC30213@svana.org> (raw)
In-Reply-To: <55AE8E6F.7030504@blackducksoftware.com>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
On Tue, Jul 21, 2015 at 02:24:47PM -0400, Todd A. Cook wrote:
> Hi,
>
> 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,
--
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
Attachments:
[application/pgp-signature] signature.asc (827B, ../20150721193741.GC30213@svana.org/2-signature.asc)
download
view thread (244+ messages) latest in thread
Message-ID: <20150721193741.GC30213@svana.org>
Permalink: ../20150721193741.GC30213@svana.org/
Also on: postgresql.org/message-id/20150721193741.GC30213@svana.org
reply
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-hackers@postgresql.org
Cc: kleptog@svana.org, tcook@blackducksoftware.com, tgl@sss.pgh.pa.us, andres@anarazel.de, masao.fujii@gmail.com
Subject: Re: WAL logging problem in 9.4.3?
In-Reply-To: <20150721193741.GC30213@svana.org>
* 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