The following talk describes an issue with how Linux may handle memory
allocation for Postgres. The issue may cause many hundreds of megabytes
not being released in some cases.
PostgreSQL and RAM usage [Feb 27, 2017]
see between minutes 33 and 39 of the talk
On 18/01/2018 17:25, Rambabu V wrote:
we are seeing idle sessions consuming memory in our database, could
you please help me how much memory an idle session can use max and how
can we find how much work_mem consuming for single process.
we are getting out of memory error,for this i'm asking above questions.