Re: check performance parameters - Mailing list pgsql-performance

From Matthew
Subject Re: check performance parameters
Date
Msg-id Pine.LNX.4.64.0804011454560.20402@aragorn.flymine.org
Whole thread Raw
In response to check performance parameters  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
List 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

pgsql-performance by date:

Previous
From: "Hell, Robert"
Date:
Subject: Cursors and different settings for default_statistics_target
Next
From: Tom Lane
Date:
Subject: Re: Cursors and different settings for default_statistics_target