With the last test I made, the database is swapping but in a very slow
way... 100K every 10 minutes and that seems to not be a problem... in
the sense that the server doesn't slow down...
Today I'll make other tests and let you know.
Thank you,
Denis
Scott Marlowe wrote:
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 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
