Re: Clearing plans

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Peter Kovacs <peter(dot)kovacs(dot)1(dot)0rc(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Scott Ribe <scott_ribe(at)killerbytes(dot)com>, "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Clearing plans
Date: 2007-01-19 14:33:12
Message-ID: 20070119143312.GC10356@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

If you use something like pgpool, you ofcourse get the advantages of
cached plans across multiple sessions, if that's what you're looking
for...

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jasbinder Singh Bali 2007-01-19 14:41:50 Re: Dynamic loading of Perl Code in Postgres functions
Previous Message Martijn van Oosterhout 2007-01-19 14:18:00 Re: Alter definition of a column