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

From: Jason Buberel <jason(at)altosresearch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Is it ever necessary to vacuum a table that only gets inserts/updates?
Date: 2011-11-17 00:24:25
Message-ID: CAAPEApFu5M29GiFJcuJK27OymxAJawfsffMhORdcfznJWsht7Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

-jason

--
Jason L. Buberel
CTO, Altos Research
http://www.altosresearch.com/
650.603.0907

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hyelluas 2011-11-17 01:07:05 can I show number of records returned by a query in a log?
Previous Message Tom Lane 2011-11-17 00:02:11 Re: How could I find the last modified procedure in the database?