From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>, "Patches" <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: New contrib: pg_reset_stats() |
Date: | 2002-08-02 02:18:34 |
Message-ID: | GNELIHDDFBOCMGBFGEFOKEHKCDAA.chriskl@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
If you still are wondering about committing it, it only allows a super user
to reset the stats:
australia=# \connect - au-php
You are now connected as new user au-php.
australia=> select pg_reset_stats();
ERROR: Only database superusers can reset statistic counters
Chris
> -----Original Message-----
> From: pgsql-patches-owner(at)postgresql(dot)org
> [mailto:pgsql-patches-owner(at)postgresql(dot)org]On Behalf Of Christopher
> Kings-Lynne
> Sent: Monday, 29 July 2002 3:14 PM
> To: Patches
> Subject: Re: [PATCHES] New contrib: pg_reset_stats()
>
>
> Oh - and could someone please test it on a multibyte install?
>
> Just need to know if I require multibyte headers to be ifdef'd.
>
> Chris
>
> > -----Original Message-----
> > From: pgsql-patches-owner(at)postgresql(dot)org
> > [mailto:pgsql-patches-owner(at)postgresql(dot)org]On Behalf Of Christopher
> > Kings-Lynne
> > Sent: Monday, 29 July 2002 3:05 PM
> > To: Patches
> > Subject: [PATCHES] New contrib: pg_reset_stats()
> >
> >
> > Here is a new contrib. Extract it in the contrib directory and
> > it will make
> > its own subdir. Needs to be added to the contrib/Makefile.
> >
> > This is a function that allows you to reset the postgres stats collector
> > from within postgres.
> >
> > It's documented, has an sql script and has been tested and works.
> >
> > This function should probably be put in the postgres backend as a
> > builtin at
> > some point methinks...
> >
> > Chris
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2002-08-02 02:55:35 | Re: New contrib: pg_reset_stats() |
Previous Message | Bruce Momjian | 2002-08-01 23:30:36 | Re: anonymous composite types for Table Functions (aka SRFs) |