Christopher Kings-Lynne wrote:
> I was thinking of writing a command line tool like 'pgtune' that looks at
> the stats views and will generate SQL code for, or do automatically the
> following:
>
> * Dropping indices that are never used
> * Creating appropriate indices to avoid large, expensive sequential scans.
>
> This would put us in the 'mysql makes my indices for me by magic' league -
> but would be far more powerful and flexible. How to do multikey indices is
> beyond me tho.
This is a great idea. I have been wanting to do something like this
myself but probably won't get the time.
Does MySQL really make indexes by magic?
Also, I had to look up the contraction for "will not" because I always
get that confused (won't). I just found a web page on it:
http://www.straightdope.com/mailbag/mwont.html
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
