Tuesday, March 01, 2011

PostgreSQL Query Cache - "pqc"

I would like to introduce a new open source software, PostgreSQL Query Cache, which enables to improve query performance extremely (10x~100x) by caching query results in front of backends.

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.