Re: VACUUM degrades performance significantly. Database becomes

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: VACUUM degrades performance significantly. Database becomes
Дата
Msg-id 87r81b20bf.fsf@stark.dyndns.tv
обсуждение исходный текст
Ответ на Re: VACUUM degrades performance significantly. Database becomes  (Vivek Khera <khera@kcilink.com>)
Список pgsql-general
Vivek Khera <khera@kcilink.com> writes:

> Your CPU usage is irrelevent here.  What's your *disk* utilization.
> Does linux have systat and/or iostat to tell you how busy your disks
> are?

I normally look at the bi/bo columns of "vmstat 1".

There does appear to be an iostat command, on debian in the sysstat package.
No idea how good it is.

--
greg

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ShmemAlloc errors
Следующее
От: Network Administrator
Дата:
Сообщение: Re: connecting to external database tables outside of the postgres database