pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
check performance parameters
2+ messages / 2 participants
[nested] [flat]

* check performance parameters
@ 2008-04-01 11:40  Sabin Coanda <sabin.coanda@deuromedia.ro>
  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 13:55  Matthew <matthew@flymine.org>
  parent: Sabin Coanda <sabin.coanda@deuromedia.ro>
  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