Re: Running analysis as part of a stored proc

Ioannis Anagnostopoulos <ioannis(at)anatec(dot)com> writes:
> Is it advisable to include a VACUUM ANALYZE <table name> within a stored
> procedure that runs as part of a batch every night?

If you're envisioning this as cleanup after the day's activities,
autovacuum will almost certainly make that unnecessary.

The typical cases where you need a manual vacuum or analyze in a stored
proc are where you need the cleanup or new stats immediately and can't
wait for autovacuum to get around to it. So if this is a step in a
process where you just modified the table heavily and you need the
cleanup done before you get to the next step, then yes it'd make sense.

regards, tom lane