Re: Too much clients connected to the PostgreSQL Database

From: Frank Lanitz <frank(at)frank(dot)uvena(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Too much clients connected to the PostgreSQL Database
Date: 2012-10-30 07:32:15
Message-ID: 508F827F.50907@frank.uvena.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 30.10.2012 02:06, schrieb rodrigo(at)paripassu(dot)com(dot)br:
> BTW, 200 seems alwfully high unless a *really* high end machine. Â You
>> may have fewer timeouts if you avoid swamping the server with a
>> "thundering herd" of requests.

I was maintaining a setup which had > 1000 connections on a not very
high-end server (12GB of Ram). It was just most of the connections were
idling most the time. Tomcat with a high number of consistent
connections for some reasons and end user stand alone clients which are
establishing a database connection on startup and keeping them until
shutdown.

Cheers,
Frank

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2012-10-30 07:50:39 Re: Too much clients connected to the PostgreSQL Database
Previous Message iamvshlbndr 2012-10-30 05:10:15 Re: PostgresQL intallation error: Unable to write inside TEMP environment variable path‏