PostgreSQL Process memory architecture - Mailing list pgsql-hackers

Hi,

I have a question regarding the memory consumption per process in PostgreSQL 9.2

Does each PostgreSQL process allocating in its own memory (Not shared memory) a cache of all the database catalog which it access during the SQL execution?

I mean does each process holds all the catalog indexes data which it accessed, all the catalog index statistics etc’ accessed

If yes is there a way to avoid this behavior?

(I asked Josh Berkus from PGExperts and he said that each process holds memory for sorts, hashes, temp tables, vaccum, etc’)

Thanks,

Lior