Re: Hot standby, conflict resolution

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Hot standby, conflict resolution
Дата
Msg-id 1232900373.2327.1462.camel@ebony.2ndQuadrant
обсуждение исходный текст
Ответ на Re: Hot standby, conflict resolution  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Hot standby, conflict resolution  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
On Fri, 2009-01-23 at 21:30 +0200, Heikki Linnakangas wrote:

> Ok, then I think we have a little race condition. The startup process 
> doesn't get any reply indicating that the target backend has
> processed 
> the SIGINT and set the cached conflict LSN. The target backend might 
> move ahead using the old LSN for a little while, even though the
> startup 
> process has already gone ahead and replayed a vacuum record.
> 
> Another tiny issue is that it looks like a new conflict LSN always 
> overwrites the old one. But you should always use the oldest
> conflicted 
> LSN in the checks, not the newest.

That makes it easier, because it is either not set, or it is set and
does not need to be reset as new conflict LSNs appear.

I can see a simple scheme emerging, which I will detail tomorrow
morning.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Hot standby, dropping a tablespace
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle