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?
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 8: explain analyze is
On Friday 19 March 2004 15:04, Tom Lane wrote:
> 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 curren
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 cou
