Re: can't handle large number of INSERT/UPDATEs

Поиск
Список
Период
Сортировка
От Matt Clark
Тема Re: can't handle large number of INSERT/UPDATEs
Дата
Msg-id 417E9752.5050506@ymogen.net
обсуждение исходный текст
Ответ на Re: can't handle large number of INSERT/UPDATEs  ("Anjan Dave" <adave@vantage.com>)
Список pgsql-performance
>I don't have iostat on that machine, but vmstat shows a lot of writes to
>the drives, and the runnable processes are more than 1:
>
> 6  1      0 3617652 292936 2791928    0    0     0 52430 1347  4681 25
>19 20 37
>
>
Assuming that's the output of 'vmstat 1' and not some other delay,
50MB/second of sustained writes is usually considered 'a lot'.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: can't handle large number of INSERT/UPDATEs
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Measuring server performance with psql and pgAdmin