Re: pgpool on Opteron server running FreeBSD 6.0

From: Vivek Khera <vivek(at)khera(dot)org>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgpool on Opteron server running FreeBSD 6.0
Date: 2006-09-08 14:48:57
Message-ID: 8BB9C45F-1558-4311-ABA5-50373B6CBBFE@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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 complete (it took less than an hour with
> Informix). Strange! Any ideas?

we're going production with a similar setup (though using 64-bit
Xeon) running FreeBSD 6.1/amd64 and pgpool. I'll check for any funny
behavior like this, but in pre-production testing we are not seeing
any interrupt storms or hight context switch.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brandon Aiken 2006-09-08 15:05:10 Re: Database design and triggers...
Previous Message Olexandr Melnyk 2006-09-08 14:23:05 Re: PostgreSQL books for beginner