On Jan 10, 2008 10:50 AM, Sim Zacks <[EMAIL PROTECTED]> wrote:
> I meant I did Vacuum Analyze.
> In any case, Aside from the vacuum analyze, I also tested it right after a 
> database restore, so there should be no need for any maintenance features.

FYI, a restore does NOT restore the stats, nor does it automatically
update them.  You have to run an analyze after a restore to get the
stats updated.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to