On Mon, Dec 14, 2015 at 12:18 PM, Vladimir Sitnikov <
sitnikov.vladi...@gmail.com> wrote:
> > a global lock would be good enough for a proof of concept that only
> evaluates cache hit ratios.
> I think emulator can be used to check hit ratios. That way we can see
> how different algorithms affect hit ratio.
> Is there a set of traces of "buffer load events"? (I did some Google
> searches like "postgresql buffer cache trace" with no luck)
> Is there an option that enables tracing of each requested buffer Id?

To get the detailed trace for each buffer, I think you can use dynamic
tracing as explained in documentation [1].

Another simple way could be to use:
 Explain (Analyze, Buffers) <sql_statement>

This will give blocks hit and read numbers which could be useful in your

[1] - http://www.postgresql.org/docs/devel/static/dynamic-trace.html

With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

Reply via email to