Re: [GENERAL] Idea for the statistics collector

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