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,
Suporte24x7 e Treinamento