Josh Berkus wrote:
> Bruce,
>
> > > Good god - how old was that email? 2002???
> >
> > Yep, and been in my mailbox since then, waiting for me to process it
> > into a TODO entry.
>
> > > > ????* Add tool to query pg_stat_* tables and report indexes that aren't
> > > > needed or tables that might need indexes
>
> pg_stat_user_indexes and pg_stat_user_tables aready give us this information.
> Further, the newsysviews are going to fill in for the remaining missing info
> (like unindexed FKs).
>
> What other tools do we need? If we're talking an interactive analysis tool
> ala pg_suggest, isn't that being worked on .... as an *add-in*? I don't see
> any place for this in the core ...
It is something need, either in core or out. Is it done enough to
remove the item?
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073