Re: pg_shmem_allocations view

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: pg_shmem_allocations view
Дата
Msg-id 20140504115056.GN12715@awork2.anarazel.de
обсуждение исходный текст
Ответ на pg_shmem_allocations view  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: pg_shmem_allocations view
Список pgsql-hackers
Hi,

On 2014-05-04 13:44:17 +0200, Andres Freund wrote:
> postgres=# SELECT * FROM pg_shmem_allocations ORDER BY size DESC;
>                  key                 |     off     |    size     | allocated
> -------------------------------------+-------------+-------------+-----------
>  Buffer Blocks                       |   286242528 | 17179869184 | t
>  Buffer Descriptors                  |   152024800 |   134217728 | t
> ...
>  OldSerXidControlData                | 17584357344 |          16 | t
> (44 rows)

Thinking about this, I think it was a mistake to not add a 'name' field
to dynamic shared memory's dsm_control_item. Right now it's very hard to
figure out which extension allocated a dsm segment. Imo we should change
that before 9.4 is out. I am not suggesting to use it to identify
segments, but just as an identifier, passed in into dsm_create().

Imo there should be a corresponding pg_dynshmem_allocations to
pg_shmem_allocations.

Greetings,

Andres Freund

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



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: pg_shmem_allocations view
Следующее
От: Andres Freund
Дата:
Сообщение: Re: pg_shmem_allocations view