Thread: Re: [GENERAL] Idea for the statistics collector
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 ... -- --Josh Josh Berkus Aglio Database Solutions San Francisco
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
>> 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? Well the pg_advisor views in pgfoundry.org are supposed to provide this. I'll probably ask Fabien to give me commits onit so i can put stuff in that :) Chris
Chris, > Well the pg_advisor views in pgfoundry.org are supposed to provide this. > I'll probably ask Fabien to give me commits on it so i can put stuff > in that :) If someone is still working on pg_advisor, suggest that they check out our work in newsysviews. I think it'll speed things up considerably if they/you build on our shoulders. -- --Josh Josh Berkus Aglio Database Solutions San Francisco