Re: Stefan's bug (was: max_standby_delay considered harmful)

Поиск
Список
Период
Сортировка
Искать
От
Simon Riggs
Тема
Re: Stefan's bug (was: max_standby_delay considered harmful)
Дата
в 09:54:10
Msg-id
1274273395.4620.138.camel@ebony
Ответ на
Список
Дерево обсуждения
Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Simon Riggs <simon@2ndQuadrant.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Simon Riggs <simon@2ndQuadrant.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Simon Riggs <simon@2ndQuadrant.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Simon Riggs <simon@2ndQuadrant.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Simon Riggs <simon@2ndQuadrant.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Simon Riggs <simon@2ndQuadrant.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Simon Riggs <simon@2ndQuadrant.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Simon Riggs <simon@2ndQuadrant.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Simon Riggs <simon@2ndQuadrant.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Simon Riggs <simon@2ndQuadrant.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Tom Lane <tgl@sss.pgh.pa.us>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Tom Lane <tgl@sss.pgh.pa.us>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Tom Lane <tgl@sss.pgh.pa.us>
Re: Stefan's bug (was: max_standby_delay considered harmful) Simon Riggs <simon@2ndQuadrant.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Robert Haas <robertmhaas@gmail.com>
Re: Stefan's bug (was: max_standby_delay considered harmful) Fujii Masao <masao.fujii@gmail.com>
On Wed, 2010-05-19 at 08:21 -0400, Tom Lane wrote:
> Robert Haas  writes:
> > On Wed, May 19, 2010 at 1:47 AM, Fujii Masao  wrote:
> >> Yes, but I prefer XLogCtl->SharedRecoveryInProgress, which is the almost
> >> same indicator as the boolean you suggested. Thought?
> 
> > It feels cleaner and simpler to me to use the information that the
> > postmaster already collects rather than having it take locks and check
> > shared memory, but I might be wrong.  Why do you prefer doing it that
> > way?
> 
> The postmaster must absolutely not take locks (once there are competing
> processes).  This is non negotiable from a system robustness standpoint.

Masao has not proposed this, in fact his proposal was to deliberately
avoid do so.

I proposed using the state recorded in xlog.c rather than attempting to
duplicate that with a second boolean in postmaster because that seems
likely to be more buggy.

-- Simon Riggs           www.2ndQuadrant.com


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Mike Fowler
Дата:
FAQ