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?
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 |