On Sun, 30 Jan 2005 22:44:15 -0600, Rich Neswold <rich.neswold@gmail.com> wrote:
> On Fri, 28 Jan 2005 10:39:26 -0600, Rich Neswold <rich.neswold@gmail.com> wrote:
> > I'll try the Dec 18th version and see if things get better...
> 
> I installed the Dec 18th pkgsrc version of PostgreSQL 7.4.3. It's been
> running for 2 days without showing the 100% CPU problem. My database
> doesn't get hit much at all, but I did run the 86 regression tests for
> the libpqxx library.

FWIW, I've been able to reproduce the problem easily with OSDB and
7.4.6 on 2.0 branch through -current.  I can only test back to July
24th on the 2.0 branch because that is when the driver for the IDE on
my test box was pulled up.

If you can install the OSDB stuff on your system and run 'gmake test'
a few times that should tell right away if it has the same problem.

-Andrew