Re: Auto-indexing

> 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