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, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
