pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedcheck performance parameters
2+ messages / 2 participants
[nested] [flat]
* check performance parameters
@ 2008-04-01 11:40 Sabin Coanda <sabin.coanda@deuromedia.ro>
2008-04-01 13:55 ` Re: check performance parameters Matthew <matthew@flymine.org>
0 siblings, 1 reply; 2+ messages in thread
From: Sabin Coanda @ 2008-04-01 11:40 UTC (permalink / raw)
To: pgsql-performance
Hi there,
I have an application accessing a postgres database, and I need to estimate
the following parameters:
- read / write ratio
- reads/second on typical load / peak load
- writes/second on typical load / peak load
Is there any available tool to achieve that ?
TIA,
Sabin
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: check performance parameters
2008-04-01 11:40 check performance parameters Sabin Coanda <sabin.coanda@deuromedia.ro>
@ 2008-04-01 13:55 ` Matthew <matthew@flymine.org>
0 siblings, 0 replies; 2+ messages in thread
From: Matthew @ 2008-04-01 13:55 UTC (permalink / raw)
To: pgsql-performance
On Tue, 1 Apr 2008, Sabin Coanda wrote:
> I have an application accessing a postgres database, and I need to estimate
> the following parameters:
>
> - read / write ratio
> - reads/second on typical load / peak load
> - writes/second on typical load / peak load
>
> Is there any available tool to achieve that ?
Assuming you have a vaguely unix/linux-ish type system, then use iostat.
Matthew
--
Reality is that which, when you stop believing in it, doesn't go away.
-- Philip K. Dick
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-04-01 13:55 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-01 11:40 check performance parameters Sabin Coanda <sabin.coanda@deuromedia.ro>
2008-04-01 13:55 ` Matthew <matthew@flymine.org>
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