Re: ram consumption

From: Petar Djurkovic <petar(dot)djurkovic(at)cbs(dot)co(dot)rs>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ram consumption
Date: 2016-05-28 17:18:29
Message-ID: 62ae0550-501f-cd12-9720-d76e5410d201@cbs.co.rs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I stop postgresql with "service postgresql stop" when I stop my web
application, postgresql running on Ubuntu 15.

Example, while running Postgresql he use 78 GB I see that on htop or top
also same state with free mem and when I stop Postgresql ram consumption
stay on 78 GB.

I every day run VACUUM(ANALYSE) and use pg_repack also autovacuum is on

This is part of my postgresql.conf:

checkpoint_timeout = 10min
max_connections = 200
shared_buffers = 12GB
effective_cache_size = 100GB
work_mem = 167772kB
maintenance_work_mem = 2GB
checkpoint_segments = 64
checkpoint_completion_target = 0.9
wal_buffers = 16MB

Best Regards,
Petar Djurkovic
On 5/28/2016 6:52 PM, Tom Lane wrote:
> Petar Djurkovic <petar(dot)djurkovic(at)cbs(dot)co(dot)rs> writes:
>> When I stop postgresql instance ram mem which postgres used stay
>> uncleared and I must restart host machine, why is that happen and how
>> can I solve this problem?
> It's unlikely that this is a bug, but: how are you stopping Postgres
> exactly? What observation convinces you that memory is not being
> reclaimed? What's the operating system?
>
>> Version of my Postgresql is 9.4.
> 9.4.which exactly?
>
> regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Gavin Flower 2016-05-28 22:16:51 Re: ram consumption
Previous Message Tom Lane 2016-05-28 16:52:03 Re: ram consumption