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?