On Jan 10, 2008 10:50 AM, Sim Zacks <sim@compulab.co.il> 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
needfor 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.