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.
On Mon, Jan 7, 2019 at 9:32 AM Kuk Hyun Kim <khk800123@xxxxxxxxx> 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
