Postgres Pro
Downloads
Home   >   mailing lists

Re: Database Cache Hit Ratio (Warning) - Mailing list pgsql-general

From Rajiv Ranjan
Subject Re: Database Cache Hit Ratio (Warning)
Date
Msg-id CAKeFoKtYzfq+SyAcchcmcZMDmyFhWWyiFWYAMYidqp5sLmoS8w@mail.gmail.com
Whole thread Raw
In response to Re: Database Cache Hit Ratio (Warning)  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
Does this unnamed monitoring tool (and undefined query) really think higher percentages are worse or are you mis-communicating? 

Forget about the tool used for monitoring, important is to monitor the "Cache hit ratio" is good or we can ignore it?


On Wed, 1 Apr 2020 at 10:44, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tuesday, March 31, 2020, Rajiv Ranjan <rajiv.mca08@gmail.com> wrote:
Hi,

Received a Database cache hit ratio warning alert from one of the monitoring tools, the threshold for the “database cache hit ratio %” is 90% for a High and 95% for Critical

Does this unnamed monitoring tool (and undefined query) really think higher percentages are worse or are you mis-communicating?

David J.


--
Thanks,
Rajiv Ranjan 

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Out of memory in big transactions after upgrade to 12.2
Next
From: Moses Mafusire
Date:
Subject: Re: Cstore_fdw issue.