On Sun, Sep 04, 2005 at 08:00:21PM -0400, huaxin zhang wrote:
> I start postgres using the -s parameter to track the number of hits to buffer.
I assume you're running postgres in single-user mode since that's
where the -s option means "print statistics." Is that what you're
doing?
> I also set both "stats_start_collector", "stats_block_level" to true
> in /usr/local/pgsql/data/postgresql.conf
>
> However, I get "(typeid = 700, len = 4, typmod = -1, byval = f)" after
> running each query. Apparently this is not manifesting buffer hit rate.
Try setting log_min_messages to debug1; that works for me in 8.0.3.
--
Michael Fuhr
