RE: Cache Hit Ratio%

Hi Fabio,

Its same across  all env's

• Shared_buffers is 2GB
• DB size is same 12GB

Query Plan in PROD Env

Hi,

I would start checking (and comparing with pre-prod) the db size, the shared_buffers size, how much data end up in cache and how are the cache layer's used.

regards,

fabio pardi

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