Richard Huxton <[EMAIL PROTECTED]> writes:
> If I pg_restore a DB and don't ANALYSE before a pl/pgsql trigger activates
> then that trigger's going to be planned based on the default stats forever
> isn't it?
Only for the life of the current backend(s).
If that's still too long for you, you could do a CREATE OR REPLACE FUNCTION
that doesn't actually change anything about the trigger function; that
will force current cached plans to be thrown away.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
