| 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: | Whole Thread | Raw Message | 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 |