Re: Scalability in postgres - Mailing list pgsql-performance

From Greg Smith
Subject Re: Scalability in postgres
Date
Msg-id alpine.GSO.2.01.0905291414480.1130@westnet.com
Whole thread Raw
In response to Re: Scalability in postgres  (Fabrix <fabrixio1@gmail.com>)
List pgsql-performance
On Fri, 29 May 2009, Fabrix wrote:

> In this application is not closing the connection, the development team
> is makeing the change for close the connection after getting the job
> done. So most connections are in idle state.  How much would this help?
> Does this could be the real problem?

Ah, now you're getting somewhere.  This is actually another subtle problem
with making max_connections really high.  It lets developers get away with
being sloppy in ways that waste large amount of server resources.

Fix that problem, re-test, and then think about changing other things.
There's no need to go through kernel changes and the lot if you can nail
the problem at its true source and get acceptable performance.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-performance by date:

Previous
From: Fabrix
Date:
Subject: Re: Scalability in postgres
Next
From: Scott Mead
Date:
Subject: Re: Scalability in postgres