On Jan 10, 2008 10:50 AM, Sim Zacks <sim@xxxxxxxxxxxxxx> 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 majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly