| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Andrew Sullivan" <andrew(at)libertyrms(dot)info>, "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] Stats Collector |
| Date: | 2002-07-31 02:32:31 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOAEGNCDAA.chriskl@familyhealth.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
> Or you might have made a number of changes to a database which has
> been running for a while, and want to see whether the changes have
> had the desired effect. (Say, whether some new index has helped
> things.)
Well out stats had gotten up in to the millions and hence were useless when
I made some query changes designed to remove a lot of seqscans. I also made
some changes that might have caused indices to no longer be used, and hence
I want to know if they ever switch from 0 uses to some uses...
If only the super user can install it - then surely the superuser can GRANT
usage permissions on it? Otherwise, how do I put in a superuser check? Do
I just do it ALTER TABLE-style?
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-07-31 02:43:07 | Re: getpid() function |
| Previous Message | Rob Brown-Bayliss | 2002-07-31 02:14:11 | Re: Questions about my strategy |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Curt Sampson | 2002-07-31 02:34:20 | Rules and Views |
| Previous Message | Curt Sampson | 2002-07-31 02:31:11 | Re: Why is MySQL more chosen over PostgreSQL? |