ckan / ckan/ckan-postgres-dev

does postgreSQL waits for some time before releasing idle connection?

Open
#1 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Makefile
Stars
1
Forks
3
PR merge metrics
No merged PRs in 30d

Description

I'm using **CKAN 2.7.2 (docker)** application.
```
max_connection = 200 (postgresql)
queuepool = 15 (Sqlalchemy)-> pool_size=5 && max_overflow=10
Ckan_default processes: 4 (ckan)
```
In my psql's pg_stat_activity table connection details are (```select * from pg_stat_activity;```):

ckandb connections : total 80 connections where active - 51, idle - 20, idle_in_transaction - 09.
ckan_datastore con : total 24 connections where active - 04, idle - 19, idle_in_transaction - 01.

We can see many connections are in `Idle` state.

Does these `Idle` connections are reusable (waiting to serve new request) or these connections are about to release(waiting for release)?

Does postgreSQL takes some time to release the idle connections?(I mean, If there are some idle connections present then, does postgreSQL waits for some time before releasing those idle connection? )

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.