"Scot Kreienkamp" <SKreien(at)la-z-boy(dot)com> writes:
>> Why not just add an 'analyze' as the last step of the restore job?
> Due to the amount of time it takes. The disks are slow enough to make a
> database-wide analyze painful since I would have to repeat it every 1-2
> hours, IE every reload time.
You claimed that before. It didn't make any sense then and it doesn't
now. There is no way that an analyze is expensive compared to a
database reload.
Maybe what you need to be doing is rethinking the strategy that involves
reloading every couple of hours...
regards, tom lane