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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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...

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


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-2017 The PostgreSQL Global Development Group