Forum OpenACS Q&A: Postgresql Memory Usage

Collapse
1: Postgresql Memory Usage
Posted by Tom Jackson on 05/18/01 10:26 PM

I just installed the AOLserver-3.4 and memory usage is definitely under control. However, now I notice that all my postmaster processes have different memory totals under top: 

22444 postgres   0   0 26524  25M 17228 S  postmaster
22177 postgres   3   0 26524  25M 17224 S  postmaster
22448 postgres   0   0 26468  25M 17224 S  postmaster
22798 postgres   3   0 27612  23M 17668 S  postmaster
22832 postgres   0   0 26912  23M 17288 S  postmaster
22143 postgres   0   0 28584  20M 18436 S  postmaster
etc...

Does this mean the total usage is the total of all these?

Collapse
2: Response to Postgresql Memory Usage (response to 1)
Posted by Petru Paler on 05/20/01 03:07 PM

No. The memory usage figure is made from adding the local process data + the shared memory segments it attaches to (run ipcs to see the shared memory segments).