Re: [GENERAL] Idea for the statistics collector - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [GENERAL] Idea for the statistics collector
Date
Msg-id 200504201723.j3KHN2d08066@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] Idea for the statistics collector  (Josh Berkus <josh@agliodbs.com>)
Responses Re: [GENERAL] Idea for the statistics collector  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
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
 


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Wierd performance issue with 8.1cvs
Next
From: "David F. Skoll"
Date:
Subject: Re: Postgres: pg_hba.conf, md5, pg_shadow, encrypted passwords