On Fri, 28 Jan 2005 02:13:34 +0000, Bob Kemp <bsd@allegory.demon.co.uk> wrote:
> Rich Neswold <rich.neswold@gmail.com> wrote:
> > PostgreSQL 7.4.3 is behaving the same way on my 2.0-RELEASE system. If
> > you have any ideas for me to try, I'd be willing to help out.
> 
> I'm running NetBSD-current from 24th Nov and had the same problem with
> PostgreSQL from pkgsrc after 18th Dec.  Using "cvs update" to wind back
> to pkgsrc as of 18 Dec 2004 fixed it, so I assumed it was a bug in pkgsrc.
> 
> Have a look at the PR I submitted for it a while ago:
> 
>     pkg/28729: PostgreSQL consumes 100% CPU after brief heavy loading
>     http://www.netbsd.org/cgi-bin/query-pr-single.pl?number=28729
> 
> Was it installed from pkgsrc?

Yes, it was installed from pkgsrc.

> Is your pkgsrc quite old?

No, I installed pkgsrc (via CVS) after installing 2.0 on my system
(which was earlier this month.) I'll try the Dec 18th version and see
if things get better... Thanks for the link!

-- 
Rich

AIM : rnezzy
ICQ : 174908475