If it was in pgpool or something similar, I could devote a separate machine just for caching results leaving the db server untouched.
BUT you would be limited to caching complete queries. There is a more efficient strategy...
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
