Re: Slow query due to slow I/O

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: Bryce Covert <bryce(at)brycecovertoperations(dot)com>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Slow query due to slow I/O
Date: 2013-12-12 20:48:23
Message-ID: CAGTBQpaUsg3qtkZvD9WqyMNV6ujt6Q2Gd8vuwQSGz328H-kFaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Dec 12, 2013 at 5:20 PM, Bryce Covert <
bryce(at)brycecovertoperations(dot)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".

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sev Zaslavsky 2013-12-12 21:08:48 slow loading of pages for SELECT query - will CLUSTER help?
Previous Message Bryce Covert 2013-12-12 20:20:58 Re: Slow query due to slow I/O