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 current backend(s).
Ah that's alright then. ANALYZE is usually the first thing I do after a
restore anyway, but thought I'd check how important it was that I remember.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
