Billy Earney <billy.earney@gmail.com> writes:
> I'm wondering if anyone would be interested in a query cache as a backend
> to postgresql?
I believe this has been suggested and rejected several times before.
Did you look through the pgsql-hackers archives?
> To invalidate cache entries, look at the transactions being committed (and
> written to WAL log, if my memory serves me) and send a message to the
> qcache process to invalidate any query which depends on the modfied
> relation (ie, table, etc)
The complication, opportunities for bugs, and general slowdown
associated with that would outweigh any possible gain, in the opinion
of most hackers who have thought about this.
regards, tom lane