Re: Verify My Database Isn't Slammed

From: Michael Beattie <mtbeedee(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Verify My Database Isn't Slammed
Date: 2012-01-05 03:43:27
Message-ID: 24766034.48.1325735007920.JavaMail.geo-discussion-forums@vbux26
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

That sounds something like there's a missing indexes or incorrect indexes. Are both apps having problems being slow or just MRBS? Is there anything about any particular queries that failed in some error log?

Without having more data on the size of the tables and how old the app is it's hard to say for sure. You could try turning on the slow query log and see what it logs and then EXPLAIN and ANALYZE to see what it is doing. Then create indexes for those queries.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Thom Brown 2012-01-05 12:25:30 Re: Verify My Database Isn't Slammed
Previous Message Joe Conway 2012-01-05 03:07:03 Re: Strategy for doing number-crunching