From: Calvin Kim <khk800123@gmail.com>
To: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Database connection pool expiration
Date: Mon, 7 Jan 2019 18:06:31 +1100
Message-ID: <80E28CE6-DCE0-4E66-8B50-EFF65923E7DD@gmail.com> (raw)
In-Reply-To: <CAGDYbUMpPPPbv0A7OKx=Epcndqk6-kR_B52zyh9JHKwgChsvmA@mail.gmail.com>
References: <CA+1h7-+RfeZns4gpWj7nh4D2jkHo6ARdHmZksng==j1VNMsStg@mail.gmail.com>
<CAGDYbUMpPPPbv0A7OKx=Epcndqk6-kR_B52zyh9JHKwgChsvmA@mail.gmail.com>
Hi,
I have checked both and they were all commented out, so they were disabled.
Could there be some other db config to check for?
Thanks.
Calvin
Sent from my iPhone
> On 7 Jan 2019, at 6:01 pm, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
>
> 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
>>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: khk800123@gmail.com, shreeyansh2014@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Database connection pool expiration
In-Reply-To: <80E28CE6-DCE0-4E66-8B50-EFF65923E7DD@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox