Peter Geoghegan <peter@2ndquadrant.com> writes:
> should expose the hash. The need to aggregate historical statistics
> just doesn't appreciably alter things here, I feel. The number of
> discrete queries that an application will execute in a week just isn't
> that different from the number that it will ever execute, I suspect.
Please don't forget that some people won't write the most effective SQL
from the get go and will rewrite problematic queries. Some people will
even rollout new features in their applications, with new queries to
implement them. Or new applications on top of the existing database.
So I don't think that the query list is that static. That said, I don't
have any idea at all about the impact of what I'm saying to your
analysis…
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support