pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Database connection pool expiration
4+ messages / 3 participants
[nested] [flat]

* Database connection pool expiration
@ 2019-01-06 22:46 Kuk Hyun Kim <khk800123@gmail.com>
  2019-01-07 07:01 ` Re: Database connection pool expiration Shreeyansh Dba <shreeyansh2014@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Kuk Hyun Kim @ 2019-01-06 22:46 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Database connection pool expiration
  2019-01-06 22:46 Database connection pool expiration Kuk Hyun Kim <khk800123@gmail.com>
@ 2019-01-07 07:01 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
  2019-01-07 07:06   ` Re: Database connection pool expiration Calvin Kim <khk800123@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Shreeyansh Dba @ 2019-01-07 07:01 UTC (permalink / raw)
  To: Kuk Hyun Kim <khk800123@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org

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
>
>

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Database connection pool expiration
  2019-01-06 22:46 Database connection pool expiration Kuk Hyun Kim <khk800123@gmail.com>
  2019-01-07 07:01 ` Re: Database connection pool expiration Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2019-01-07 07:06   ` Calvin Kim <khk800123@gmail.com>
  2019-01-09 15:57     ` Re: Database connection pool expiration Shreeyansh Dba <shreeyansh2014@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Calvin Kim @ 2019-01-07 07:06 UTC (permalink / raw)
  To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org

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
>> 

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Database connection pool expiration
  2019-01-06 22:46 Database connection pool expiration Kuk Hyun Kim <khk800123@gmail.com>
  2019-01-07 07:01 ` Re: Database connection pool expiration Shreeyansh Dba <shreeyansh2014@gmail.com>
  2019-01-07 07:06   ` Re: Database connection pool expiration Calvin Kim <khk800123@gmail.com>
@ 2019-01-09 15:57     ` Shreeyansh Dba <shreeyansh2014@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Shreeyansh Dba @ 2019-01-09 15:57 UTC (permalink / raw)
  To: Calvin Kim <khk800123@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org

How are you connecting to the Database? What message you get?

If you are using the middleware (like pgbouncer or pgpool-II) for
connections, These tools also have its own connection timeout parameter
settings.

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


On Mon, Jan 7, 2019 at 12:36 PM Calvin Kim <khk800123@gmail.com> wrote:

> 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
>>
>>

^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2019-01-09 15:57 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-01-06 22:46 Database connection pool expiration Kuk Hyun Kim <khk800123@gmail.com>
2019-01-07 07:01 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-07 07:06   ` Calvin Kim <khk800123@gmail.com>
2019-01-09 15:57     ` Shreeyansh Dba <shreeyansh2014@gmail.com>

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