| Lists: | pgsql-hackers |
|---|
| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Idea for the statistics collector |
| Date: | 2005-04-20 16:50:11 |
| Message-ID: | 200504200950.11517.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | josh(at)agliodbs(dot)com |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Idea for the statistics collector |
| Date: | 2005-04-20 17:23:02 |
| Message-ID: | 200504201723.j3KHN2d08066@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | josh(at)agliodbs(dot)com, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Idea for the statistics collector |
| Date: | 2005-04-21 01:47:58 |
| Message-ID: | 4267064E.2010702@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
>> 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 on it so i can put stuff
in that :)
Chris
| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Idea for the statistics collector |
| Date: | 2005-04-21 02:08:09 |
| Message-ID: | 200504201908.09965.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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