Re: Is it ever necessary to vacuum a table that only gets inserts/updates?

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