Monitoring postgres slowdowns

From: isuzu91(at)hotmail(dot)com (Steve Bacon)
To: pgsql-general(at)postgresql(dot)org
Subject: Monitoring postgres slowdowns
Date: 2002-06-17 22:12:01
Message-ID: 8bcc9d75.0206171412.1d3677e9@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
is there any way to "look under the hood" when slowdowns occur? We
have a tomcat / postgres site with each app having it's own server.
The db machine is a dual CPU / RAID 5 / 2GB RAM box running RedHat
Linux 7.1 and Postgres 7.1.3
The two machines are connected via a hub on which no other machines
are present (i.e. private link). shmall is set to 805306368 and shmmax
is 536870912

We seem to have daily slowdowns, and the only tools I know of are top
and ps, which are pretty general and only tell you when something is
cranking along. I'd like to better be able to 1) determine if indeed
something strange is happening with our postgres install and 2) what
it might be. I could find no pointers in the faq.

Out user load isn't very heavy (max of 200 users), yet occasionally
things just crawl. Looking at the tomcat machine shows most memory
free low CPU usage, so all signs point to the DB machine - but how to
tell if something's wrong / what exactly it is doing at the moment?
It's getting frustrating because when it happens everyone looks at me,
and I have no idea how to pinpoint what's happening.

(Also, we are doing a nightly vacuum --analyze (we tried doing hourly
vacuums on 6 of our update-heavy tables, but that slowed things down
too much))

thanks,
-Steve

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff MacDonald 2002-06-17 22:19:39 Re: website design
Previous Message Joshua D. Drake 2002-06-17 21:54:48 Re: read this and puke