I have DB of size ~16GB Windows Server 2008 R2 (up to date).
We moved from Postgres v9.2.4 to Postgres v9.3.4 and now Postgres v9.3.4 memory usage is growing until is takes all the windows physical memory. On windows start up, physical memory usage is around 13%. In 48H this memory usage will increase to 70% and most of the memory is used by postgres.
But on Postgres v9.2.4 everything was fine, memory usage was reasonable. But I'm not able to understand what's wrong with Postgres v9.3.4.
To keep my application running, I had to restart the server for every 48hrs.
Did anyone had same issue and found any solutions? It will be highly appreciated it someone can help me with this.
shared_buffers
,work_mem
,maintenance_work_mem
,max_connections
, etc. How do you measure the memory use? What actually happens if it starts using lots of RAM, are there any real effects?