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.djurkovic@cbs.co.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