Re: Sudden drop in DBb performance - Mailing list pgsql-performance

From Tomas Vondra
Subject Re: Sudden drop in DBb performance
Date
Msg-id 785367bd0412b17bcd89350bcd703de6.squirrel@sq.gransy.com
Whole thread Raw
In response to Re: Sudden drop in DBb performance  (Andy Colson <andy@squeakycode.net>)
Responses Re: Sudden drop in DBb performance
List pgsql-performance
On 5 Září 2011, 15:51, Andy Colson wrote:
> On 09/05/2011 02:48 AM, Tomas Vondra wrote:
>> That seems a bit slow ... 27MB/s for writes and 41MB/s forreads is ait
>> slow with 8 drives.
>>
>> Tomas
>>
>>
>
> Agreed, that's really slow.  A single SATA drive will get 60 MB/s.  Did
> you run Bonnie while the VM's were up and running?
>
>    root@host:~# vmstat
>    procs -----------memory---------- ---swap-- -----io---- -system--
> ----cpu----
>     r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy
> id wa
>     0  0      0 308024 884812 40512932    0    0   464   168  353   92  4
> 2 84  9
>
>
> Only one line?  That does not help much.  Can you run it as 'vmstat 2' and
> let it run while a few slow queries are performed?  Then paste all the
> lines?

And maybe a few lines from "iostat -x 2" too.

BTW what kind of raid is it? Is it hw or sw based? Have you checked health
of the drives?

Are you sure there's nothing else using the drives (e.g. one of the VMs,
rebuild of the array or something like that)?

Tomas


pgsql-performance by date:

Previous
From: Richard Shaw
Date:
Subject: Re: Rather large LA
Next
From: "Tomas Vondra"
Date:
Subject: Re: Sudden drop in DBb performance