Re: Streaming replication on 9.1-beta2 after pg_restore is very slow

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Streaming replication on 9.1-beta2 after pg_restore is very slow
Дата
Msg-id 14178.1310051645@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Streaming replication on 9.1-beta2 after pg_restore is very slow  (David Hartveld <David.Hartveld@mendix.com>)
Ответы Re: Streaming replication on 9.1-beta2 after pg_restore is very slow  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Список pgsql-general
Looking back, I notice that you built with gcc 4.6.0.  At least on Red
Hat machines, that gcc has a rather nasty optimization bug that breaks
WAL replay, with symptoms that seem to match what you have here ---
namely, the replay process quits and has to be restarted every few pages.
I'm betting Debian hasn't fixed that bug yet either and so you need this
post-beta2 patch:

http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=c2ba0121c73b7461331104a46d140156e847572a

            regards, tom lane

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Streaming replication on 9.1-beta2 after pg_restore is very slow
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: Streaming replication on 9.1-beta2 after pg_restore is very slow