Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group