Re: Function query plan

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: Dany De Bontridder <dany(at)alchimerys(dot)be>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Function query plan
Date: 2006-05-05 21:23:15
Message-ID: 87fyjo88u4.fsf@suzuka.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dany De Bontridder <dany(at)alchimerys(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Volkan YAZICI 2006-05-05 21:46:01 intarray internals
Previous Message Dany De Bontridder 2006-05-05 20:53:57 Re: Function query plan