On Wed, 2005-07-27 at 12:53, Jim C. Nasby wrote: > On Wed, Jul 27, 2005 at 04:46:56PM +0200, denis@xxxxxxxxxxx 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend