Re: Too much clients connected to the PostgreSQL Database - Mailing list pgsql-general

From Frank Lanitz
Subject Re: Too much clients connected to the PostgreSQL Database
Date
Msg-id 508F827F.50907@frank.uvena.de
Whole thread Raw
In response to Re: Too much clients connected to the PostgreSQL Database  (rodrigo@paripassu.com.br)
Responses Re: Too much clients connected to the PostgreSQL Database  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Am 30.10.2012 02:06, schrieb rodrigo@paripassu.com.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


Attachment

pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Too much clients connected to the PostgreSQL Database
Next
From: John R Pierce
Date:
Subject: Re: Too much clients connected to the PostgreSQL Database