Postgres Pro
Downloads
Home   >   mailing lists

[PERFORM] Postgres uses too much RAM - Mailing list pgsql-performance

From Hans Braxmeier
Subject [PERFORM] Postgres uses too much RAM
Date
Msg-id VI1PR04MB1136D70E029EB2D40F60EEBA99EE0@VI1PR04MB1136.eurprd04.prod.outlook.com
Whole thread Raw
Responses Re: [PERFORM] Postgres uses too much RAM  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-performance
Tree view

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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: [PERFORM] Postgres performance issue
Next
From: Vincent Veyron
Date:
Subject: Re: [PERFORM] Speed differences between two servers