| From: | "Tomas Vondra" <tv(at)fuzzy(dot)cz> |
|---|---|
| To: | "Andy Colson" <andy(at)squeakycode(dot)net> |
| Cc: | "Tomas Vondra" <tv(at)fuzzy(dot)cz>, "Gerhard Wohlgenannt" <wohlg(at)ai(dot)wu(dot)ac(dot)at>, pgsql-performance(at)postgresql(dot)org, "Heinz-Peter Lang" <heinz(at)langatium(dot)net>, "Gerhard Wohlgenannt" <wohlg(at)ai(dot)wu-wien(dot)ac(dot)at>, "Weichselbraun, Albert" <albert(dot)weichselbraun(at)wu(dot)ac(dot)at> |
| Subject: | Re: Sudden drop in DBb performance |
| Date: | 2011-09-05 14:15:23 |
| Message-ID: | 785367bd0412b17bcd89350bcd703de6.squirrel@sq.gransy.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gerhard Wohlgenannt | 2011-09-05 14:15:27 | Re: Sudden drop in DBb performance |
| Previous Message | Gerhard Wohlgenannt | 2011-09-05 14:14:50 | Re: Sudden drop in DBb performance |