Re: Verify My Database Isn't Slammed
От
Michael Beattie
Тема
Re: Verify My Database Isn't Slammed
Дата
Msg-id
24766034.48.1325735007920.JavaMail.geo-discussion-forums@vbux26
Ответ на
Verify My Database Isn't Slammed (Carlos Mennens)
Список
Дерево обсуждения
Verify My Database Isn't Slammed Carlos Mennens <carlos.mennens@gmail.com>
Re: Verify My Database Isn't Slammed Michael Beattie <mtbeedee@gmail.com>
Re: Verify My Database Isn't Slammed Thom Brown <thom@linux.com>
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.
В списке pgsql-novice по дате отправления