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 the next time you call the function. -Doug ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org