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 по дате отправления: