|
For benchmarking TPS, have a look at pgbench if you haven't already done so.
Kieren > From: plaporte@xxxxxxxxx > To: laurenz.albe@xxxxxxxxxx; > Subject: Re: monitoring TPS and IOPS > Date: Wed, 27 May 2015 09:01:33 +0000 > > Laurenz. Thank you. > 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. > For TPS we will explore pgBadger. > Regards, > __ > Pascal > > > > > On 27/05/15 10:43, "Albe Laurenz" <laurenz.albe@xxxxxxxxxx> wrote: > > >Pascal Laporte wrote: > >> In what ways are we able to pull information about transactions and I/O per second ? > >> For things like load testing we need this type of information. > >> In Oracle we retrieve it from the AWR reports. > >> Are PG admins also looking at this data, and how is that collected/presented? > > > >For operating system parameters like I/O and CPU load you have to use operating > >system tools, like "sar" on UNIX. > > > >For measuring things like TPS during a test run, I'd recommend pgBadger > >(http://dalibo.github.io/pgbadger/). > > > >Yours, > >Laurenz Albe > > -- > Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin |
