Richard Huxton <dev(at)archonet(dot)com> 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