Alvaro Herrera wrote: > Jean-David Beyer wrote: > >> How do I reset the counters in pg_stat_database and pg_stat_all_tables? >> I tried just restarting postgres, but it seems to be saved in the database, >> not just in the RAM of the server. > > There is a function called pg_stat_reset() or some such. I'll find it. > >> I suppose that blks_read and blks_hit are zero because there are 8 GBytes >> RAM on this machine and I give 2GBytes to shared_buffers = 253000 so that >> all sits in RAM. > > Perhaps you have stats_block_level set to off? True, I will turn them on. > >> I know there have been rollbacks but I do a REINDEX, CLUSTER, and VACUUM >> ANALYZE before starting the inserts in question. > > You do all three on the same tables? That seems pretty pointless. A > sole CLUSTER has the same effect. I was only doing this to be sure to clean everything up for this data gathering process and wanted to know I did not miss anything. > >> Do I need to do a VACUUM FULL ANALYZE instead? > > No. > -- .~. Jean-David Beyer Registered Linux User 85642. /V\ PGP-Key: 9A2FC99A Registered Machine 241939. /( )\ Shrewsbury, New Jersey http://counter.li.org ^^-^^ 09:50:01 up 22 days, 3:08, 4 users, load average: 4.29, 4.17, 4.11 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
