From: Bruno Wolff III <bruno@wolff.to>
To: Catalin <catalin@cyber.ro>
Cc: pgsql-performance@postgresql.org
Subject: Re: Daily crash
Date: Thu, 27 Feb 2003 07:30:11 -0600
Message-ID: <20030227133011.GA28616@wolff.to> (raw)
In-Reply-To: <00da01c2de5f$04154f40$0201a8c0@catalin>
References: <3E5E50B8.10803.E998B57@localhost>
<00da01c2de5f$04154f40$0201a8c0@catalin>
On Thu, Feb 27, 2003 at 14:51:59 +0200,
Catalin <catalin@cyber.ro> wrote:
> i'm afraid i don't have any logs.
> i have the default redhat instalation of postgres 7.0.2 which comes with no
> logging enabled.
You should upgrade to 7.2.4 or 7.3.2. (7.3 has schemas and that may make
upgrading harder which is why you might consider just going to 7.2.4.)
> i will try to enable logging and post the logs to the list !
>
> anyway in PHP when trying to connect to the crashed SQL server i get the
> error message:
> Too many connections...
You are going to want the number of allowed connections to match the number
of simultaneous requests possible from the web server. Typically this is
the maximum number of allowed apache processes which defaults to something
like 150. The default maximum number of connections to postgres is about
32. You will also want to raise the number of shared buffers to about
1000 (assuming you have at least a couple hundred of megabytes of memory),
not just to 2 times the new maximum number of connections. This may require
to change the maximum amount of shared memory allowed by your operating
system. Also take a look at increasing sort mem as well. You don't want
this too high because each sort gets this much memory and in your situation
it may be that you could have a lot of sorts runing at the same time
(dpending on the types of queries being done).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: bruno@wolff.to, catalin@cyber.ro
Subject: Re: Daily crash
In-Reply-To: <20030227133011.GA28616@wolff.to>
References: <3E5E50B8.10803.E998B57@localhost> <00da01c2de5f$04154f40$0201a8c0@catalin> <20030227133011.GA28616@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox