Re: Connection problem under extreme load. - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: Connection problem under extreme load.
Date
Msg-id 39811055.AA513CCE@alumni.caltech.edu
Whole thread Raw
In response to Connection problem under extreme load.  (Jeffery Collins <collins@onyx-technologies.com>)
List pgsql-general
> We have been doing some load testing with postgresql, and we have been
> getting the following error when libpq attempts to connect to the
> backend.  This only happens occasionally and, as I said under extreme
> load (e.g. load average 30+ on a single processor Sun).
> connectDBStart() -- connect() failed: Connection refused
> Is the postmaster running at 'localhost' and accepting connections on
> Unix socket '6700'?
> Has anyone seen this before or know what could be happening?  One theory
> that we have is that the connection request timed out because the server
> was under such heavy load that it couldn't respond to the request.  Is
> this possible?

You are increasing the number of allowed connections to above 32, right?
The runtime default is 32, but it can be increased with a commandline
switch.

                     - Thomas

pgsql-general by date:

Previous
From: brianb-pggeneral@edsamail.com
Date:
Subject: Backup/dump of huge tables and performance
Next
From: Jeffery Collins
Date:
Subject: Re: Connection problem under extreme load.