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
Re: Slow query due to slow I/O |
| Список | 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 по дате отправления: