Re: monitoring TPS and IOPS - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: monitoring TPS and IOPS
Date
Msg-id A737B7A37273E048B164557ADEF4A58B366169DB@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: monitoring TPS and IOPS  ("Pascal Laporte (plaporte)" <plaporte@cisco.com>)
List 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 by date:

Previous
From: Kieren Scott
Date:
Subject: Re: monitoring TPS and IOPS
Next
From: girish R G peetle
Date:
Subject: PostgreSQL Dump based backup using pipe