PostgreSQL Query Cache, a new open source software, which enables to improve query performance extremely (10x~100x) by caching query results, has been launched.
http://code.google.com/p/pqc/
PostgreSQL Query Cache:
waits connections on the different port from the clients.
delegates queries in front of the backends, like a proxy.
intercepts and caches SELECT query results.
also manages lifecycle of the query cache.
For more information, please visit following presentation:
http://www.slideshare.net/uptimeforce/postgresql-query-cache-pqc
This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.