I need to measure the memory used by postgres under various loads in my application.How to calculate the exact memory used by postgres for OS:Windows as well as linux ?
Thanks,
CM J
On Mon, Jun 15, 2009 at 5:37 PM, Massa, Harald Armin <chef@xxxxxxx> wrote:
CMJ,same system.Even under moderate load in my application, each of the postgres process occupies some 25 MB memory leading to total postgres memory usage of 500+ MB. Now, how do i limit the memory used by each
how did you measure those 25MB and those 500+MB MEMORY usage?
I guess you are running windows task manager and looking into the default memory column. That is adress space used, rather then memory used. So Postgres is using 500MB of adress space; share_memory of those processes is accounted for every process.
Look within additional columns of taskmanager to find the one giving the private memory of the process.
Especially on windows you should update to the latest 8.3.x PostgreSQL.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
LASIK good, steroids bad?
