Re: [GENERAL] pgpool on Opteron server running FreeBSD 6.0

2006-09-08 Thread Vivek Khera
On Sep 7, 2006, at 3:31 PM, andy rost wrote: a) The system load is 20 b) WCPU values for the 14 active pgpool processes exceed 20% c) Context switching on the server jumps as high as 250,000 The application now takes 4 (with pgpool) rather than less than two hours (without pgpool) to

[GENERAL] pgpool on Opteron server running FreeBSD 6.0

2006-09-07 Thread andy rost
I'm running postgres 8.1.3 on a 2-CPU dual-core Opteron server with 8-Gigs of RAM. The server's operating system is FreeBSD 6.0. We migrated our client applications from Informix and went through all of the standard steps to resolve differences between the two databases packages. However,