Postgres memory usage per connection

Поиск
Список
Период
Сортировка
От Raj Gandhi
Тема Postgres memory usage per connection
Дата
Msg-id CALU_HCM1XKRf6FC5g-ermFUn=W7OKZF_McjYUWgfGUUwfcycxA@mail.gmail.com
обсуждение исходный текст
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "drum.lucas@gmail.com"
Дата:
Сообщение: Re: pg_dump - ERROR - PostgreSQL 9.2
Следующее
От: jaime soler
Дата:
Сообщение: Re: Questions regarding handling of Postgres' stats data in case of tmpfs