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

From: Hans Schou <hans(dot)schou(at)gmail(dot)com>
To: andreas(at)a-kretschmer(dot)de
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Shared buffers increased but cache hit ratio is still 85%
Date: 2018-07-18 10:25:56
Message-ID: CAApBw34p1iZxeWZkXsQbTmAUhFO=GkJxWoTSDDYtVNgu22MzkQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 18, 2018 at 10:44 AM Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
wrote:

>
> ||pg_stat_reset()
>

Thanks, I guess we can see the result in a few days.

BTW, strang command: it only reset current database and it can't take db as
parameter.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fabio Pardi 2018-07-18 10:32:45 Re: Is it ok to run vacuum full verbose command for live database for the tables which has more dead tuples?
Previous Message Raghavendra Rao J S V 2018-07-18 09:13:30 Is it ok to run vacuum full verbose command for live database for the tables which has more dead tuples?