Dany De Bontridder <[EMAIL PROTECTED]> writes:
> And after a vacuum analyze, the plan can change ??
I don't *think* that the pl/pgsql query plan cache is ever currently
flushed in the lifetime of a given connection. If you disconnect and
reconnect with a fresh backend it will be planned again th
On Friday 05 May 2006 13:06, Douglas McNaught wrote:
> "Paul Mackay" <[EMAIL PROTECTED]> writes:
> > I understand that the query plan of a function is determined at
> > CREATION and remains the same whatever the parameter(s) value. I
> > suppose then that this plan is stored somewhere in a system t
"Paul Mackay" <[EMAIL PROTECTED]> writes:
> I understand that the query plan of a function is determined at
> CREATION and remains the same whatever the parameter(s) value. I
> suppose then that this plan is stored somewhere in a system table ?
You are misinformed. It's determined the first time
I understand that the query plan of a function is determined at CREATION and remains the same whatever the parameter(s) value. I suppose then that this plan is stored somewhere in a system table ? Is it possible to consult this plan ?
Thanks,Paul
