Re: 9.1.3 backends getting stuck in 'startup'

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 9.1.3 backends getting stuck in 'startup'
Дата
Msg-id 9495.1335573058@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 9.1.3 backends getting stuck in 'startup'  (Jeff Frost <jeff@pgexperts.com>)
Ответы Re: 9.1.3 backends getting stuck in 'startup'  (Jeff Frost <jeff@pgexperts.com>)
Список pgsql-bugs
Jeff Frost <jeff@pgexperts.com> writes:
> and I've got 81 more that do not contain bufmgr.c and are also not block on
> LWLockAcquire.

Hm ... no smoking gun in what you showed so far.  I also took another
look through 9.1 bufmgr.c, and I'm darned if I can see any code path
there that holds a buffer mapping lock for any long interval.

One possible theory is that you're using pg_buffercache_pages(), which
does take all those locks.  It tries its best to not hold them long,
but with a sufficiently large buffer cache there could be an issue.
(What is the shared_buffers setting on this installation, anyway?)

            regards, tom lane

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

Предыдущее
От: Jeff Frost
Дата:
Сообщение: Re: 9.1.3 backends getting stuck in 'startup'
Следующее
От: Jeff Frost
Дата:
Сообщение: Re: 9.1.3 backends getting stuck in 'startup'