Re: Cached Query Plans (was: global prepared statements) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Cached Query Plans (was: global prepared statements)
Date
Msg-id 13998.1207935908@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cached Query Plans (was: global prepared statements)  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> PFC wrote:
>> So, where to go from that ? I don't see a way to implement this without 
>> a (backwards-compatible) change to the wire protocol, because the clients 
>> will want to specify when a plan should be cached or not. Since the user  
>> should not have to name each and every one of the statements they want to 
>> use plan caching, I see the following choices :

> I don't understand the point here.  We already have cached plans: you
> send a Parse.  You can then Bind/Execute many times.
> Maybe what we need is support for this in libpq, so that PHP can use it?

We already have that, too ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Remove lossy-operator RECHECK flag?
Next
From: Gregory Stark
Date:
Subject: Re: Commit fest queue