> 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 pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026