Re: WAL logging problem in 9.4.3?

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: WAL logging problem in 9.4.3?
Дата
Msg-id 20150721193741.GC30213@svana.org
обсуждение исходный текст
Ответ на Re: WAL logging problem in 9.4.3?  ("Todd A. Cook" <tcook@blackducksoftware.com>)
Ответы Re: WAL logging problem in 9.4.3?  (Andres Freund <andres@anarazel.de>)
Список 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@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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: pgbench stats per script & other stuff
Следующее
От: Kevin Grittner
Дата:
Сообщение: brin index vacuum versus transaction snapshots