Re: pg_shmem_allocations view

On 04-05-2014 08:44, Andres Freund wrote:
> I've more than once wanted to know what allocated shared memory in
> postgres installation is used for. Especially with more an more
> extensions around that's quite useful.
>
A few years ago I had to provide such information an did something
similar. Is it useful? Yes. However, it is a developer's feature.

> On 2014-05-04 13:44:17 +0200, Andres Freund wrote:
> 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().
>
+1.

> Imo there should be a corresponding pg_dynshmem_allocations to
> pg_shmem_allocations.
>
... or another boolean column (say 'dynamic') and just one view.

--
Euler Taveira Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento