[PERFORM] Cache hit ratio

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?

Re: [PERFORM] Cache hit ratio

Jean Arnaud Jean.Arnaud 'at' inrialpes.fr writes: Hi Is there a way to get the cache hit ratio in PostGreSQL ? When you activate: stats_block_level = true stats_row_level = true you will get global statistics, per table and per index, about read disk blocks and saved reads thanks

Re: [PERFORM] Cache hit ratio

Set log_executor_stats=true; Then look in the log after running statements (or tail -f logfile). - Luke On 4/3/07 7:12 AM, Jean Arnaud [EMAIL PROTECTED] wrote: Hi Is there a way to get the cache hit ratio in PostGreSQL ? Cheers ---(end of

Re: [PERFORM] Cache hit ratio

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 --

Re: [PERFORM] Cache hit ratio

Guillaume, which shows the index on primary keys is used, but is always read from disk. or, more likely, from the FS cache. But, the clock time used for the request is actually identical when using -B 1000 or -B 2. I suppose the kernel is bringing the performance difference thanks to