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