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 <carlos.mennens@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: Strategy for doing number-crunching
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Verify My Database Isn't Slammed