Re: Shared buffers increased but cache hit ratio is still 85%

From: Adrien NAYRAT <adrien(dot)nayrat(at)anayrat(dot)info>
To: Hans Schou <hans(dot)schou(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Shared buffers increased but cache hit ratio is still 85%
Date: 2018-07-19 07:35:19
Message-ID: 559d2702-e024-6e37-d5e2-e891a6f136ae@anayrat.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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,

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra Rao J S V 2018-07-19 11:00:39 Re: Is it ok to run vacuum full verbose command for live database for the tables which has more dead tuples?
Previous Message Chris 2018-07-19 06:35:50 Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?