anomalous, persistent high loads with postgresql 6.5.1

From: Bill Garrett <garrett(at)memesis(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: anomalous, persistent high loads with postgresql 6.5.1
Date: 1999-08-10 21:39:18
Message-ID: Pine.LNX.4.10.9908101733090.10579-100000@isomorph.memesis.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've searched the list archives and read the FAQ, neither of which seem to
describe my current situation:

I'm running Linux 2.2.10 on a production webserver, along with PostgreSQL
6.5.1 (in RPM format from ftp.postgresql.org). My main database is a set
of names/addresses/etc. tables for our membership, about 60,000 records
apiece, with indexes in all the right places. Whenever I run any sort of
involved query, the postmaster process kicks into CPU-eating mode; even
after I've made sure no more queries running (including the original),
postmaster/postgres processes keep the system at a load average of 3 and
rising; the only way it seems to subside is if I kill and restart
postmaster, which is obviously a problem ^_^;;

Is this a weird OS/dbms/query combination bug, or am I just doing
something horribly wrong?

Browse pgsql-general by date

  From Date Subject
Next Message Aaron Seigo 1999-08-10 21:53:18 Re: [GENERAL] Selecting between dates
Previous Message Dmitry Morozovsky 1999-08-10 17:39:03 Re: [GENERAL] ALTER TABLE