PostgreSQL Process memory architecture
От | Ben Zeev, Lior |
---|---|
Тема | PostgreSQL Process memory architecture |
Дата | |
Msg-id | 59E5FDBE8F3B144F8FCF35819B39DD4C16242D33@G6W2498.americas.hpqcorp.net обсуждение исходный текст |
Ответы |
Re: PostgreSQL Process memory architecture
Re: PostgreSQL Process memory architecture |
Список | pgsql-hackers |
<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>
В списке pgsql-hackers по дате отправления: