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
[cid:image001(dot)jpg(at)01D664CA(dot)E3463990]

From: Fabio Pardi <f(dot)pardi(at)portavita(dot)eu>
Sent: dinsdag 28 juli 2020 10:13
To: pgsql-admin(at)lists(dot)postgresql(dot)org
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

On 28/07/2020 10:04, soumik(dot)bhattacharjee(at)kpn(dot)com<mailto:soumik(dot)bhattacharjee(at)kpn(dot)com> wrote:
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