From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
---|---|
To: | "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com>, "postgres performance list" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: cpu bound postgresql setup. |
Date: | 2010-06-23 17:43:15 |
Message-ID: | 4C220163020000250003291B@gw.wicourts.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Your response somehow landed in the subject line, apparently
truncated. I'll extract that to the message body and reply to what
made it through.
Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com> wrote:
> Firstly many thanks for responding. I am concerned because the
> load averages have increased and users complaining of slowness.
If performance has gotten worse, then something has changed. It
would be helpful to know what. More users? New software? Database
growth? Database bloat? (etc.)
> I do not change settings frequenly.
That doesn't mean your current settings can't be changed to make
things better.
> I was curious if there is any half dead component in th
Have you reviewed what shows up if you run (as a database
superuser)?:
select * from pg_stat_activity;
You might want to review this page:
http://wiki.postgresql.org/wiki/SlowQueryQuestions
-Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2010-06-23 17:58:01 | Re: Aggressive autovacuuming ? |
Previous Message | Rajesh Kumar Mallah | 2010-06-23 17:30:01 | Re: cpu bound postgresql setup. Firstly many thanks for responding. I am concerned because the load averages have increased and users complaining of slowness. I do not change settings frequenly. I was curious if there is any half dead component in th |