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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
