On Friday 05 May 2006 13:06, Douglas McNaught wrote: > "Paul Mackay" <mackaypaul@xxxxxxxxx> 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 that function is > executed in a given backend, and stored in backend-local memory. > There's no way that I know of to look at it. And after a vacuum analyze, the plan can change ?? D.
