Postgres Pro
Downloads
Home   >   mailing lists

Cache Hit Ratio% - Mailing list pgsql-admin

From
Subject Cache Hit Ratio%
Date
Msg-id 2A91BEF8171A5349931391E0C721CC5396962191@CPEMS-KPN301.KPNCNL.LOCAL
Whole thread Raw
Responses Re: Cache Hit Ratio%  (Fabio Pardi <f.pardi@portavita.eu>)
List pgsql-admin
Tree view

Dear Experts,

 

We have done production migration from Oracle to PostgreSQL.

 

Could you please help me to know where to look out for - the Cache Hit Ratio is always at 65.72% , but in lower Pre-Prod env it’s kind of 95%.

 

As such no major slowness is reported by the customer so far.

 

 

Thanks

 

 

 

 

 

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: How can i be certain autovacuum is causing reuse if table still grows
Next
From: Fabio Pardi
Date:
Subject: Re: Cache Hit Ratio%