Thread: Re: [GENERAL] Idea for the statistics collector

Re: [GENERAL] Idea for the statistics collector

From
Josh Berkus
Date:
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


Re: [GENERAL] Idea for the statistics collector

From
Bruce Momjian
Date:
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
 


Re: [GENERAL] Idea for the statistics collector

From
Christopher Kings-Lynne
Date:
>> 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


Re: [GENERAL] Idea for the statistics collector

From
Josh Berkus
Date:
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