Re: Resetting a single statistics counter - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Resetting a single statistics counter
Date
Msg-id 28548.1264356832@sss.pgh.pa.us
Whole thread Raw
In response to Re: Resetting a single statistics counter  (Euler Taveira de Oliveira <euler@timbira.com>)
Responses Re: Resetting a single statistics counter
Re: Resetting a single statistics counter
List pgsql-hackers
Euler Taveira de Oliveira <euler@timbira.com> writes:
> Magnus Hagander escreveu:
>> Off to make it two separate functions.. (seems much more user-friendly
>> than a single function with an extra argument, IMHO)

> +1. But as Simon said _single_ is too ugly. What about
> pg_stat_reset_user_{function,relation}?

That implies that the operations wouldn't work against system tables;
which they do.  I think a bigger problem is that "reset_single_table"
seems like it might be talking about something like a TRUNCATE, ie,
it's not clear that it means to reset counters rather than data.
The pg_stat_ prefix is some help but not enough IMO.  So I suggest
pg_stat_reset_table_counters and pg_stat_reset_function_counters.

(BTW, a similar complaint could be made about the previously committed
patch: reset shared what?)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bernd Helmle
Date:
Subject: Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns
Next
From: Simon Riggs
Date:
Subject: Re: tab completion for prepared transactions?