Horton

Re: [HACKERS] Speedups

Vadim B. Mikheev <vadim@sable.krasnoyarsk.su>

View thread
From: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
To: Peter T Mount <psqlhack@maidast.demon.co.uk>
Cc: ocie@paracel.com, pgsql-hackers@postgreSQL.org
Date: 1998-03-05T02:29:39Z
Lists: pgsql-hackers 
Peter T Mount wrote:
> 
> On Wed, 4 Mar 1998 ocie@paracel.com wrote:
> 
> > This may sound like an obvious question, but if a user defines a
> > query, do we save the query plan?  This would reduce the
> > communications between the client and server (a small gain), and allow
> > the server to start executing the query as soon as it recognized the
> > name of the stored query and parsed the arguments.
> 
> Not sure ofhand, but it would be useful for JDBC's PreparedStatement and
> CallableStatement classes

We can implement it very easy, and fast. Execution plan may be reused
many times. Is this feature in standard ? 
What is proposed syntax if not ?

Vadim