> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Andrew - Supernews > Sent: Thursday, May 05, 2005 4:55 PM > To: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Views, views, views! (long) > > On 2005-05-05, Josh Berkus <josh@agliodbs.com> wrote: > > And, as Lance points out, these system views would help as a diagnostic > view > > for support engineers. Actually, I'll second that; I've had cause to > > recommend the CVS system views more than a dozen times to pgsql newbies > on > > IRC. For example, there is an easy query you can do using the new > system > > views (thanks, Andrew!) to check what unindexed foriegn keys you have.
Equally interesting would be: How many duplicate keys do I have? An interesting database option might be: For any foreign key, if there is no existing inversion entry index then build one. Another interesting database option might be: Check the system catalogs for duplicate indexes and remove them if there are any two completely identical (in columns, asc/desc and type). > Another popular query that gets asked on IRC is "how do I find out what > permissions have been granted to user X?" Try doing _that_ one in the > system catalogs. Obviously, this is a clear oversight by the standards committee. PostgreSQL is clearly not the only database with this important need. > -- > Andrew, Supernews > http://www.supernews.com - individual and corporate NNTP services > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
