Postgres memory usage per connection

From: Raj Gandhi <raj01gandhi(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Postgres memory usage per connection
Date: 2016-02-02 11:57:04
Message-ID: CALU_HCM1XKRf6FC5g-ermFUn=W7OKZF_McjYUWgfGUUwfcycxA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am using Postgres 9.3.10 on Linux with the following memory related
configuration:

effective_cache_size = 128MB

shared_buffers = 8MB

work_mem = 1MB

maintenance_work_mem = 16MB

Work memory is configured to 1 MB but some of the backend processes
(corresponding to client connections) are using 50-90MB of PSS memory.

How do I find out where rest of the memory is consumed?

Is there service side cache like prepared SQL cache etc. used per
connection?

There are two types of applications accessing the Postgres using jdbc
driver and Postgres odbc driver respectively.

Thanks,

Raj

Browse pgsql-admin by date

  From Date Subject
Next Message jaime soler 2016-02-03 09:19:08 Re: Questions regarding handling of Postgres' stats data in case of tmpfs
Previous Message drum.lucas@gmail.com 2016-02-02 01:02:38 Re: pg_dump - ERROR - PostgreSQL 9.2