Martijn van Oosterhout <kleptog@xxxxxxxxx> 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