> Probably both, but if it's done there should be options to:
>
> .) disable it completely or by table/database or even threshold or
> disk free parameters (indicies can be large)
> .) log any auto-created databases to inform the DBA.
> .) if disabled optionally log when it would have created an index on
> the fly. (suggest an index)
> .) expire old and unused auto-created indecies.
>
> Generally Postgresql assumes the user knows what he's doing, but
> it couldn't hurt too much to provide an option to have it assist
> the user.
I want to implement a SET PERFORMANCE_TIPS, hopefully for 7.2:
* Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM
ANALYZE, and CLUSTER
I think suggesting items to the adminstrator is the way to go.
--
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
