keep alive and running query

From: desmodemone <desmodemone(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: keep alive and running query
Date: 2013-12-15 18:08:32
Message-ID: CAEs9oF=opcWyjuNqudShBTE5O4VdNvu6yObpxec7zrRkMob0_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,
I am testing keep alive on PostgreSQL 9.2 and 9.3 on Centos 6.X
.
As I tested and saw until now, the keep alive functions as follow [if I
understand correctly and it's not a bug] :
When a connection it's in idle state or in idle in transaction, if the
connection with client it's broken for a number of keep alive, the backend
will be terminated.

By the way if this could be ok in an OLTP enviroment, because the average
time of a query is << the time of keep alive, in a DWH enviroment could be
a problem.
Imagine your application server, where there is an ETL, will go down for 1
minute and your transactions are still running on the DWH database, that
transactions could run for hours before the
keep alive will terminate them, because they are in transaction state and
not idle or idle in transaction.

Are some tricks about ? solutions ?

Kind Regards

Mat

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2013-12-16 09:31:48 Re: keep alive and running query
Previous Message bricklen 2013-12-13 23:05:20 Re: script to drop and build all indexes in database