Re: invalidating cached plans - Mailing list pgsql-hackers

From Neil Conway
Subject Re: invalidating cached plans
Date
Msg-id 423663C5.80906@samurai.com
Whole thread Raw
In response to Re: invalidating cached plans  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: invalidating cached plans  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: invalidating cached plans
Next
From: "Qingqing Zhou"
Date:
Subject: Re: invalidating cached plans