Hello.
I am curious what (if any) reliable solution/workaround there is in
cases where objects that are a part of a currently cached query plan
disappear unexpectedly.
Using JDBC and pooled connections, our production system has at any
time 120 or so live connections, most in an idle state. They
Jerry Sievers <[EMAIL PROTECTED]> writes:
> Any of these connections that may have previously executed PL
> functions which planned an index lookup are now going to fault if same
> index goes away.
> Had wondered if a postmaster 'reload' would elicit a recompiling of
> func query plans (did *not*
Tom Lane <[EMAIL PROTECTED]> writes:
> Jerry Sievers <[EMAIL PROTECTED]> writes:
> > Any of these connections that may have previously executed PL
> > functions which planned an index lookup are now going to fault if same
> > index goes away.
>
> > Had wondered if a postmaster 'reload' would elic