Re: slow queries, possibly disk io

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: slow queries, possibly disk io
Дата
Msg-id 42967810.8040700@familyhealth.com.au
обсуждение исходный текст
Ответ на slow queries, possibly disk io  (Josh Close <narshe@gmail.com>)
Ответы Re: slow queries, possibly disk io  (Josh Close <narshe@gmail.com>)
Список pgsql-performance
> I have some queries that have significan't slowed down in the last
> couple days. It's gone from 10 seconds to over 2 mins.
>
> The cpu has never gone over 35% in the servers lifetime, but the load
> average is over 8.0 right now. I'm assuming this is probably due to
> disk io.

You sure it's not a severe lack of vacuuming that's the problem?

Chris

В списке pgsql-performance по дате отправления:

Предыдущее
От: Dawid Kuroczko
Дата:
Сообщение: Re: slow queries, possibly disk io
Следующее
От: "Marc Mamin"
Дата:
Сообщение: Re: Optimising queries involving unions