On 11/16/11 4:24 PM, Jason Buberel wrote:
> Just wondering if there is ever a reason to vacuum a very large table
> (> 1B rows) containing rows that never has rows deleted.
>
> Under what circumstance would the table benefit from a vacuum?
no updates either?
you still want to do a vacuum analyze every so often to update the
statistics used by the planner.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast