Skip site navigation (1) Skip section navigation (2)

Re: Behaviour patterns on pgsql (7.1.3)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: denis(at)startsiden(dot)no
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Behaviour patterns on pgsql (7.1.3)
Date: 2002-10-30 19:09:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Denis Braekhus <denis(at)startsiden(dot)no> writes:
> Every now and then postgresql gets "too busy" and these patterns emerge :

> - some connections are just idling and not being reaped (presumably either the 
> browser/client or the apache webserver timed out the request)
> - these connections stack up to a point where the other "live" queries are 
> handled so inefficiently that pgsql enters a "bad downwards spiral".
> (Meaning it cannot serve enough requests fast enough due to high load. The 
> number of connections increases, giving again more load, and so on ... )

This strikes me as a fault on the client side, not in Postgres --- to
wit, poor connection management.  It is not Postgres' job to kill idle
client connections.

But having said that, I do not think that idle connections per se would
cause any performance degradation on the server side.  Perhaps they also
have open transactions that are holding locks that other queries need?
That again is really a client-side bug...

			regards, tom lane

In response to


pgsql-admin by date

Next:From: Andrew PerrinDate: 2002-10-30 20:53:15
Subject: URGENT: undoing a mistake
Previous:From: Peter EisentrautDate: 2002-10-30 18:53:57
Subject: Re: pg_hba.conf on win32

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group