> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly