Re: check performance parameters

From: Matthew <matthew(at)flymine(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: check performance parameters
Date: 2008-04-01 13:55:51
Message-ID: Pine.LNX.4.64.0804011454560.20402@aragorn.flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2008-04-01 15:30:05 Re: Cursors and different settings for default_statistics_target
Previous Message Hell, Robert 2008-04-01 12:14:25 Cursors and different settings for default_statistics_target