Skip site navigation (1) Skip section navigation (2)

Reinitialising stats once only without restarting

From: "Anton Melser" <melser(dot)anton(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Reinitialising stats once only without restarting
Date: 2007-12-20 10:05:20
Message-ID: 92d3a4950712200205j3bb24e8ct1bb18a306a9ae9f8@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi,
Sorry but I couldn't find the answer to this...

I would like to empty all stats (pg_stat_all_tables probably mostly)
so I can get an idea of what's going on now. Is this possible? I
didn't want to just go deleting without knowing what it would do...
Thanks
Anton

-- 
echo '16i[q]sa[ln0=aln100%Pln100/snlbx]sbA0D4D465452snlbxq' | dc
This will help you for 99.9% of your problems ...

Responses

pgsql-performance by date

Next:From: Dimitri FontaineDate: 2007-12-20 11:14:34
Subject: Re: Minimizing dead tuples caused by update triggers
Previous:From: Tom LaneDate: 2007-12-20 07:07:08
Subject: Re: Dual core Opterons beating quad core Xeons?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group