RE: Cache Hit Ratio%

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

 

This are the values for

 

  • effective_cache_size = 6GB
  • OS RAM = 25GB

Thanks..

 

From: Bhattacharjee, Soumik
Sent: dinsdag 28 juli 2020 10:36
To: Fabio Pardi <f.pardi@xxxxxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: 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

 

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

On 28/07/2020 10:04, soumik.bhattacharjee@xxxxxxx 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

 

 

 

 

 

 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux