Postgres Pro
Downloads
Home   >   mailing lists

Is it ever necessary to vacuum a table that only gets inserts/updates? - Mailing list pgsql-general

From Jason Buberel
Subject Is it ever necessary to vacuum a table that only gets inserts/updates?
Date
Msg-id CAAPEApFu5M29GiFJcuJK27OymxAJawfsffMhORdcfznJWsht7Q@mail.gmail.com
Whole thread Raw
Responses Re: Is it ever necessary to vacuum a table that only gets inserts/updates?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: sunpeng
Date:
Subject: hi, firends, what's the difference between using PostgreSQL's share buffer and os's file buffer?
Next
From: John R Pierce
Date:
Subject: Re: Is it ever necessary to vacuum a table that only gets inserts/updates?