Thread: Execution plan caching

Hi,

I have recently used the MS SQL Server 2005 database, and found out that
there is no mecanism where an execution plan can be reused between two
successive calls to a view. This is only true with stored procedures.

Is that also true with the Postgresql engine?

Philippe

Philippe Lang wrote:
> Hi,
>
> I have recently used the MS SQL Server 2005 database, and found out that
> there is no mecanism where an execution plan can be reused between two
> successive calls to a view. This is only true with stored procedures.
>
> Is that also true with the Postgresql engine?

Well, if you prepare "SELECT * FROM my_view" then the plan for that will
be cached. In general though, the query will be planned each time.

--
   Richard Huxton
   Archonet Ltd

"Philippe Lang" <philippe.lang@attiksystem.ch> writes:

> Hi,
>
> I have recently used the MS SQL Server 2005 database, and found out that
> there is no mecanism where an execution plan can be reused between two
> successive calls to a view. This is only true with stored procedures.
>
> Is that also true with the Postgresql engine?

To the best of my knowledgle, if you PREPARE a query that uses a view,
either explicitly or implicitly via your database driver, the plan
will be cached.

-Doug