From: Kieren Scott <kierenscott@hotmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: monitoring TPS and IOPS
Date: Wed, 27 May 2015 09:07:16 +0000
Message-ID: <DUB127-W43251DC827B34F5CCAAFCDAECB0@phx.gbl> (raw)
In-Reply-To: <B909CAD5-7725-45F6-B1EB-E78A6A55C3F1@cisco.com>
References: <36080D0D-56C4-4393-A08C-63979BD83600@cisco.com>
<C9DAA6F1-A70F-44B0-80F4-E049E8619788@cisco.com>
<A737B7A37273E048B164557ADEF4A58B36616933@ntex2010i.host.magwien.gv.at>
<B909CAD5-7725-45F6-B1EB-E78A6A55C3F1@cisco.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
For benchmarking TPS, have a look at pgbench if you haven't already done so.
http://www.postgresql.org/docs/devel/static/pgbench.html
Kieren
> From: plaporte@cisco.com
> To: laurenz.albe@wien.gv.at;
> Subject: Re: [ADMIN] 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@wien.gv.at> 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin =
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kierenscott@hotmail.com
Subject: Re: monitoring TPS and IOPS
In-Reply-To: <DUB127-W43251DC827B34F5CCAAFCDAECB0@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox