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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
