Re: Verify My Database Isn't Slammed - Mailing list pgsql-novice

From Michael Beattie
Subject Re: Verify My Database Isn't Slammed
Date
Msg-id 24766034.48.1325735007920.JavaMail.geo-discussion-forums@vbux26
Whole thread Raw
In response to Verify My Database Isn't Slammed  (Carlos Mennens <carlos.mennens@gmail.com>)
List pgsql-novice
That sounds something like there's a missing indexes or incorrect indexes.  Are both apps having problems being slow or
justMRBS?  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
turningon the slow query log and see what it logs and then EXPLAIN and ANALYZE to see what it is doing.  Then create
indexesfor those queries. 

pgsql-novice by date:

Previous
From: Joe Conway
Date:
Subject: Re: Strategy for doing number-crunching
Next
From: Thom Brown
Date:
Subject: Re: Verify My Database Isn't Slammed