On Tue, Sep 15, 2015 at 12:28 PM, HEARNE, TIMOTHY S <th1618@att.com> wrote:
This is my second plea for assistance. Can anyone assist me? I have attempted to download a couple of different tools from the PostgreSQL site. One would not compile on our server, pg_top-3.7.0, and another was targeted for PostgreSQL 9.3 and later.
If you have any questions, please feel free to contact me.
Tim, by looking at the top output:
top - 09:47:30 up 330 days, 23:12, 1 user, load average: 2.79, 3.37, 3.14
I agree with your server guy in that the apps running on this server (including postgres) use about 14 GB RAM. The rest is used for caching filesystem's data.
The rough but simple math here is Mem used + Swap used - cached: 193 + ,7 - 179.5 = 14.2 GB
I assume you want postgres to use more RAM directly (you should know it benefits a lot from the Linux disk cache but at a greater overhead cost).
Please, don't follow up here. Ask in the postgres Administration list and someone will be able to explain why your postgres DB configuration uses this amount of RAM.