Re: Cache hit ratio

From: Ben
Subject: Re: Cache hit ratio
Date: ,
Msg-id: Pine.LNX.4.64.0704031032200.26177@localhost.localdomain
(view: Whole thread, Raw)
In response to: Cache hit ratio  (Jean Arnaud)
List: pgsql-performance

Tree view

Cache hit ratio  (Jean Arnaud, )
 Re: Cache hit ratio  (Guillaume Cottenceau, )
  Re: Cache hit ratio  (Josh Berkus, )
 Re: Cache hit ratio  ("Luke Lonergan", )
 Re: Cache hit ratio  (Ben, )

Have you looked at the pg_stat_* views? You must enable stats collection
to see any data in them, but that's probably what you're looking for.

On Tue, 3 Apr 2007, Jean Arnaud wrote:

> Hi
>
> Is there a way to get the cache hit ratio in PostGreSQL ?
>
> Cheers
>
> --
> -- Jean Arnaud
> -- Projet SARDES
> -- INRIA Rhône-Alpes / LSR-IMAG
> -- http://sardes.inrialpes.fr/~jarnaud
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>              http://archives.postgresql.org
>


pgsql-performance by date:

From: Ron
Date:
Subject: Re: SCSI vs SATA
From: Geoff Tolley
Date:
Subject: Re: SCSI vs SATA