On 2/9/12 2:41 PM, Peter van Hardenberg wrote: > Hmm, perhaps we could usefully aggregate auto_explain output.
The other option is to take a statistical approach. After all, what you want to do is optimize average response times across all your user's databases, not optimize for a few specific queries. So one thought would be to add in pg_stat_statements to your platform ... something I'd like to see Heroku do anyway. Then you can sample this across dozens (or hundreds) of user databases, each with RPC set to a slightly different level, and aggregate it into a heat map. That's the way I'd do it, anyway. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
