Hi, 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 <c...@ghum.de> 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? >