On Mon, Nov 22, 2004 at 06:26:09PM +0000, Nicola Pero wrote: > Is there a way to explictly flush cached plans ? Is there a way to > prevent the caching of the plan in the stored procedure ?
You can prevent plan caching in PL/pgSQL by using EXECUTE. See the "Executing Dynamic Commands" section in the PL/pgSQL chapter of the documentation. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
