Dany De Bontridder <dany@xxxxxxxxxxxxx> 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