Add the number of pinning backends to pg_buffercache's output

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Add the number of pinning backends to pg_buffercache's output
Дата
Msg-id 20140412122501.GS14419@alap3.anarazel.de
обсуждение исходный текст
Ответы Re: Add the number of pinning backends to pg_buffercache's output  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-hackers
Hi,

The last week I twice had the need to see how many backends had some
buffers pinned. Once during development and once while analyzing a stuck
vacuum (waiting for a cleanup lock).
I'd like to add a column to pg_buffercache exposing that. The name I've
come up with is 'pinning_backends' to reflect the fact that it's not the
actual pincount due to the backend private arrays.

I'll add this patch to to 2014-06 CF.

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Вложения

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

Предыдущее
От: "MauMau"
Дата:
Сообщение: Re: [bug fix] pg_ctl always uses the same event source
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: Problem with txid_snapshot_in/out() functionality