Re: Sudden drop in DBb performance

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: Sudden drop in DBb performance
Дата
Msg-id 785367bd0412b17bcd89350bcd703de6.squirrel@sq.gransy.com
обсуждение исходный текст
Ответ на Re: Sudden drop in DBb performance  (Andy Colson <andy@squeakycode.net>)
Ответы Re: Sudden drop in DBb performance  (Gerhard Wohlgenannt <wohlg@ai.wu.ac.at>)
Список 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 по дате отправления:

Предыдущее
От: Richard Shaw
Дата:
Сообщение: Re: Rather large LA
Следующее
От: "Tomas Vondra"
Дата:
Сообщение: Re: Sudden drop in DBb performance