Re: Postgresql with max_connections=4096 - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Postgresql with max_connections=4096
Date
Msg-id 1122488864.15145.114.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Postgresql with max_connections=4096  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: Postgresql with max_connections=4096
List pgsql-general
On Wed, 2005-07-27 at 12:53, Jim C. Nasby wrote:
> On Wed, Jul 27, 2005 at 04:46:56PM +0200, denis@edistar.com wrote:
> > I'm now testing with pg_pool installed on each apache frontend with 260
> > pg_pool preforked clients in each machine.
> >
> > The database seems to work better. At least when it goes to swap it
> > doesn't stop working...
>
> Wait, are you saying your database server is swapping? You'll never get
> any kind of performance if that's the case.

IF it swaps out unused code / data and leaves it, that's fine, but if
it's constantly swapping out then yeah, that's a VERY bad thing.

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: duplicate messages?
Next
From: "Jonathan Villa"
Date:
Subject: Upgrading from 7.1