| From: | Hans Braxmeier <hans(dot)braxmeier(at)outlook(dot)com> |
|---|---|
| To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Postgres uses too much RAM |
| Date: | 2017-05-08 20:23:14 |
| Message-ID: | VI1PR04MB1136D70E029EB2D40F60EEBA99EE0@VI1PR04MB1136.eurprd04.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hello,
on our old server (120 GB RAM) PostgreSQL 9.4.5 was using less than 10 GB of ram. On our new server (same system) Postgres 9.4.11 is using up to 40 GB Ram. Especially each idle process is consuming 2.4 GB: postgres 30764 8.3 2.4 3358400 3215920 ? Ss 21:58 0:24 postgres: testuser testdb [local] idle
Summing up PG needs currently 72.14GB (also the slab_cache was increasing from 20 GB to 40 GB. ). For monitoring we are using munin. Is this a bug of 9.4.11 or what could be wrong?
postgresmain.conf did not change:
max_connections = 40
effective_cache_size = 64GB
shared_buffers = 1GB
work_mem = 8MB
checkpoint_segments = 32
checkpoint_timeout = 10min
checkpoint_completion_target = 0.9
checkpoint_warning = 30s
constraint_exclusion = off
Thanks, Hans
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vincent Veyron | 2017-05-08 22:24:41 | Re: Speed differences between two servers |
| Previous Message | Scott Marlowe | 2017-05-08 18:50:41 | Re: Postgres performance issue |