<div class="WordSection1"><p class="MsoNormal">Hi,<p class="MsoNormal"> <p class="MsoNormal">I have a question
regardingthe memory consumption per process in PostgreSQL 9.2<p class="MsoNormal"> <p class="MsoNormal">Does each
PostgreSQLprocess allocating in its own memory (Not shared memory) a cache of all the database catalog which it access
duringthe SQL execution?<p class="MsoNormal">I mean does each process holds all the catalog indexes data which it
accessed,all the catalog index statistics etc’ accessed<p class="MsoNormal"> <p class="MsoNormal">If yes is there a way
toavoid this behavior?<p class="MsoNormal"> <p class="MsoNormal">(I asked Josh Berkus from PGExperts and he said that
eachprocess holds memory for sorts, hashes, temp tables, vaccum, etc’)<p class="MsoNormal"> <p
class="MsoNormal">Thanks,<pclass="MsoNormal">Lior<p class="MsoNormal"> </div>