Monitoring postgres slowdowns
От | isuzu91@hotmail.com (Steve Bacon) |
---|---|
Тема | Monitoring postgres slowdowns |
Дата | |
Msg-id | 8bcc9d75.0206171412.1d3677e9@posting.google.com обсуждение исходный текст |
Ответы |
Re: Monitoring postgres slowdowns
Re: Monitoring postgres slowdowns Re: Monitoring postgres slowdowns |
Список | 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
В списке pgsql-general по дате отправления: