Re: Hot Standby remaining issues

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Hot Standby remaining issues
Дата
Msg-id 1259751614.13774.21183.camel@ebony
обсуждение исходный текст
Ответ на Re: Hot Standby remaining issues  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Hot Standby remaining issues
Список pgsql-hackers
On Wed, 2009-12-02 at 12:49 +0200, Heikki Linnakangas wrote:

> If a read-only transaction holds a lot of locks, consuming so much
> lock space that there's none left for the startup process to hold the
> lock it wants, it will abort and bring down postmaster. The patch
> attempts to kill any conflicting lockers, but those are handled fine
> already (if there's any conflicting locks, LockAcquire will return
> LOCKACQUIRE_NOT_AVAIL anyway). The problem is with non-conflicting
> locks using up the lock space.

Oh dear, another "nuke 'em all from orbit" scenario. Will do.

-- Simon Riggs           www.2ndQuadrant.com



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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Hot Standby remaining issues
Следующее
От: Laurent Laborde
Дата:
Сообщение: Re: Cost of sort/order by not estimated by the query planner