Postgres Pro
Downloads
Home   >   mailing lists

Re: Database connection pool expiration - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Database connection pool expiration
Date
Msg-id CAGDYbUMpPPPbv0A7OKx=Epcndqk6-kR_B52zyh9JHKwgChsvmA@mail.gmail.com
Whole thread Raw
In response to Database connection pool expiration  (Kuk Hyun Kim <khk800123@gmail.com>)
Responses Re: Database connection pool expiration  (Calvin Kim <khk800123@gmail.com>)
List pgsql-admin
Tree view
There may be several performance factors which might be causing the DB connection expired before completing long running transactions. However, you can consider tweaking statement_timeout and idle_in_transaction_session_timeout parameter.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Mon, Jan 7, 2019 at 9:32 AM Kuk Hyun Kim <khk800123@gmail.com> wrote:
Hi,

Recently, developers are saying that the DB connection is getting
expired causing issue while running long transactions.

Is there a such configuration setting in Postgres and what would be
the default and recommended value for this?

Regards,
Calvin

pgsql-admin by date:

Previous
From: "rsimmons514@gmail.com"
Date:
Subject:
Next
From: Calvin Kim
Date:
Subject: Re: Database connection pool expiration