Martijn van Oosterhout <kleptog@svana.org> writes:
> On Thu, Jan 18, 2007 at 10:08:24PM +0100, Peter Kovacs wrote:
>> Are the plans cached per connection? Why not globally?
> Because global plan caching is much harder and nobody has done it yet?
The idea's been discussed before, and there are at least three problems
with it:
* unpredictability of shared-memory requirement
* plan cache would become a contention hot-spot
* much greater need for explicit cache management operations ("restart
your session" would no longer substitute for a flush-the-cache command)
regards, tom lane