Re: Database Cache Hit Ratio (Warning)

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Database Cache Hit Ratio (Warning)
Дата
Msg-id CAKFQuwYFdU-acE9j_HgONaQ-3oBSjNO63pB0qXJ7ppT=LcEokw@mail.gmail.com
обсуждение исходный текст
Ответ на Database Cache Hit Ratio (Warning)  (Rajiv Ranjan <rajiv.mca08@gmail.com>)
Список pgsql-general
On Fri, Apr 3, 2020 at 5:17 AM Rajiv Ranjan <rajiv.mca08@gmail.com> wrote:
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?

The query at least would help, since it seems to be measuring something other that "cache hit ratio".

I'm not in a position to judge whether monitoring "cache hit ratio" is something you should be doing in your situation.  It provides information and is fairly cheap to capture and store.  From the sounds of it you should probably continue capturing the data but turn off the alert.  That way if there is a problem the data still exists to be considered.  The metric itself does not measure something of critical importance.

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: Backing out of privilege grants rabbit hole
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Cstore_fdw issue.