> 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
