Re: pgtune

Jacqui Caren-home wrote:
> we had a rather neat tool for oracle some
> years ago that would connect to a live database and monitor the QEP
> (query execution plan) cache for badly indexed queries etc.
> It would use this information (with the schema meta data) to suggest
> creation and deletion of indices or norm or denorm of tables.
> ...
> My questions is - is there anything out there "similar" for Pg?

We have a service like that:  http://www.tuningcloud.com/

And some of Enterprise DB's PostgreSQL products have a tool named
Dynatune that tweaks the configuration of a running server:
http://www.enterprisedb.com/docs/en/8.3/suppguide/EnterpriseDB_Supplement_EN_8.3-15.htm


I'm not sure how much they actually look at queries to make those
decisions though.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us