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

Re: Clearing global statistics

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>, Magnus Hagander <magnus(at)hagander(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Clearing global statistics
Date: 2010-01-14 18:11:23
Message-ID: 26349.1263492683@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Greg Smith <greg(at)2ndquadrant(dot)com> writes:
> Tom Lane wrote:
>> Actually, that brings up a more general question: what's with the
>> enthusiasm for clearing statistics *at all*?

> ... Right now, you're still carrying around 
> the history of the bad period forever though, and every check of the 
> pg_stat_bgwriter requires manually subtracting the earlier values out.  

Seems like a more appropriate solution would be to make it easier to do
that subtraction, ie, make it easier to capture the values at a given
time point and then get deltas from there.  It's more general (you could
have multiple saved sets of values), and doesn't require superuser
permissions to do, and doesn't have the same potential for
damn-I-wish-I-hadn't-done-that moments.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Hitoshi HaradaDate: 2010-01-14 18:32:32
Subject: Re: review: More frame options in window functions
Previous:From: Fujii MasaoDate: 2010-01-14 18:00:06
Subject: Re: archive_timeout behavior for no activity

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