Re: Function query plan - Mailing list pgsql-general

From Douglas McNaught
Subject Re: Function query plan
Date
Msg-id 87fyjo88u4.fsf@suzuka.mcnaught.org
Whole thread Raw
In response to Re: Function query plan  (Dany De Bontridder <dany@alchimerys.be>)
List pgsql-general
Dany De Bontridder <dany@alchimerys.be> 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 the next time
you call the function.

-Doug

pgsql-general by date:

Previous
From: Sean Hamilton
Date:
Subject: Rules on Select
Next
From: Volkan YAZICI
Date:
Subject: intarray internals