Re: monitoring TPS and IOPS

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: monitoring TPS and IOPS
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B366169DB@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: monitoring TPS and IOPS  ("Pascal Laporte (plaporte)" <plaporte@cisco.com>)
Список pgsql-admin
Pascal Laporte wrote:
> For IOPS when doing load testing we would like to tell if the IO requests made by the DB can be
> handled by the server.
> In oracle this information is stored in tables and so wondering if similar data can be found in PG as
> well.
> I’m not sure how feasible it will be using OS tools.

That works fine in my experience (which is on Linux).

I watch out for the I/O queue size, the service time and the I/O utilization.
When the queue size increases, it is an inication that the system cannot keep
up with the load.

Yours,
Laurenz Albe

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

Предыдущее
От: Kieren Scott
Дата:
Сообщение: Re: monitoring TPS and IOPS
Следующее
От: girish R G peetle
Дата:
Сообщение: PostgreSQL Dump based backup using pipe