Scott Marlowe wrote:
> You might want to schedule analyzes to run every thirty minutes or every
> hour.
I doubt that is necessary or wise. Rerunning ANALYZE should only be
necessary when the distribution of your data changes significantly --
e.g. after a bulk load or deletion of a lot of content. IMHO In most
circumstances, running ANALYZE once a day is more than sufficient.
-Neil