Re: Slow query due to slow I/O

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: Slow query due to slow I/O
Дата
Msg-id CAGTBQpaUsg3qtkZvD9WqyMNV6ujt6Q2Gd8vuwQSGz328H-kFaQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Slow query due to slow I/O  (Bryce Covert <bryce@brycecovertoperations.com>)
Ответы Re: Slow query due to slow I/O  (Bryce Covert <bryce@brycecovertoperations.com>)
Re: Slow query due to slow I/O  (Bryce Covert <bryce@brycecovertoperations.com>)
Список pgsql-performance

On Thu, Dec 12, 2013 at 5:20 PM, Bryce Covert <bryce@brycecovertoperations.com> wrote:
I don't have much info on disks, since this is a virtual server on linode. It is running ubuntu 12.04, 8cpus, 4GB ram, 95GB ext3 volume (noatime). Hopefully that's helpful.

Bryce


Well, did you run benchmarks? How many IOPS do you get from the volumes?

Try running "iostat -x -m -d 10" while the slow query is running and pasting the results (or a relevant sample of them).

Also, do run "explain (analyze, buffers)" instead of plain "explain analyze".

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

Предыдущее
От: Bryce Covert
Дата:
Сообщение: Re: Slow query due to slow I/O
Следующее
От: Bryce Covert
Дата:
Сообщение: Re: Slow query due to slow I/O