What to do in case of PostgreSQL cache hit ratio too low trigger?

Question

PostgreSQL

Good afternoon!
To monitor PostgreSQL, I use triggers from Alexey Lisovsky https://habr.com/post/234481/
On the PostgreSQL server, the trigger "PostgreSQL cache hit ratio too low (84.34%)" remains on for a long time.
What should I do in this case? Tell me please.
Thanks

Answer 1

Why do you care? :)
Well, yes, you have more data than "should" get from the file system cache, instead of the postgres cache. Specifically, this metric can be corrected by increasing the size of shared_buffers, but this will not affect performance for the better (and may get worse).
If you see performance problems, then you need to diagnose and fix them (start by checking the indexes), and not the metric.

Answer 2

For some reason, it has become fashionable not to write error?
I ask everyone who does not write an error handler - are you sure that order and justice reign in the world, harmony has infected IT and rid the world of such concepts as validity, the answer 4xx and 5xx and other boring and useless things?

Answer 3

I suspect that the problem is that the server returns invalid JSON. Hang up an error handler and see what the problem is.

Answer 4

It may be that the PHP code throws a NOT - Warning error and the code is executed further, the error immediately goes into the response result SUCCESS along with JSON ... It turns out a porridge of text shorter ...
PS This guy has a simple error ... I just shared the problem so that the other does not been looking for the problem for hours...