Re: WAL logging problem in 9.4.3?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: "Todd A(dot) Cook" <tcook(at)blackducksoftware(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andres Freund <andres(at)anarazel(dot)de>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: WAL logging problem in 9.4.3?
Date: 2015-07-21 19:37:41
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-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(at)svana(dot)org>
> He who writes carelessly confesses thereby at the very outset that he does
> not attach much importance to his own thoughts.
-- Arthur Schopenhauer

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2015-07-21 19:42:38 brin index vacuum versus transaction snapshots
Previous Message Fabien COELHO 2015-07-21 18:41:35 Re: pgbench stats per script & other stuff