Re: posgres tunning - Mailing list pgsql-general

From Michael Fuhr
Subject Re: posgres tunning
Date
Msg-id 20070722034705.GB55184@winnie.fuhr.org
Whole thread Raw
In response to posgres tunning  ("Arnaldo Gandol" <agacode@gmail.com>)
List pgsql-general
On Sat, Jul 21, 2007 at 09:54:35PM -0500, Arnaldo Gandol wrote:
>  I have a drupal site working with postgres that does not tolerate more
> than 200 concurrent connections(it is not hardware fault).

What does "not tolerate" mean?  Does the database refuse connections
beyond 200?  Does it permit connections but performance suffers?  Or
something else?

> Does anybody know how to adjust postgres parameters and what are them?,
> or how to get a better performance in any way?

We'll need to know more about the nature of the problem before we
can make recommendations.  For configuration guidelines see the
performance-related documents at Power PostgreSQL:

http://www.powerpostgresql.com/Docs

--
Michael Fuhr

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: encodings
Next
From: "Sibte Abbas"
Date:
Subject: Re: 8.2.4 signal 11 with large transaction