Postgres Pro
Downloads
Home   >   mailing lists

Re: Shared buffers increased but cache hit ratio is still 85% - Mailing list pgsql-general

From Adrien NAYRAT
Subject Re: Shared buffers increased but cache hit ratio is still 85%
Date
Msg-id 559d2702-e024-6e37-d5e2-e891a6f136ae@anayrat.info
Whole thread Raw
In response to Shared buffers increased but cache hit ratio is still 85%  (Hans Schou <hans.schou@gmail.com>)
List pgsql-general
Tree view 
On 07/18/2018 10:26 AM, Hans Schou wrote:
> Am I doing something wrong or should some history be cleared?

Hi,

FIY, check_pgactivity save the diff between each call to compute the 
real hit ratio : https://github.com/OPMDG/check_pgactivity

Regards,

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: Do we need yet another IDE (SQL development assistant) forPostgreSQL?
Next
From: Raghavendra Rao J S V
Date:
Subject: Re: Is it ok to run vacuum full verbose command for live database for the tables which has more dead tuples?