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(at)gmail(dot)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
>
>