Re: invalidating cached plans

Neil Conway <neilc@samurai.com>

From: Neil Conway <neilc@samurai.com>
To: Oliver Jowett <oliver@opencloud.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2005-03-15T04:25:41Z
Lists: pgsql-hackers
Oliver Jowett wrote:
> Does this mean that clients that use PREPARE/Parse need to handle "plan 
> invalidated" as a possible response to EXECUTE/Bind, or will the backend 
> keep the query string / parse tree around and replan on next execution?

The latter -- the client won't be aware that replanning took place. (If 
your prepared queries take minutes of planning time, perhaps this is 
something you *would* like to be made aware of, however...)

-Neil