Hi Fabio,
Its same across all env's
- Shared_buffers is 2GB
- DB size is same 12GB
Query Plan in PROD Env
From: Fabio Pardi <f.pardi@xxxxxxxxxxxx>
Sent: dinsdag 28 juli 2020 10:13
To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Re: Cache Hit Ratio%
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
