Postgres Pro
Downloads
Home   >   mailing lists

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

From John R Pierce
Subject Re: Is it ever necessary to vacuum a table that only gets inserts/updates?
Date
Msg-id 4EC4930A.6050503@hogranch.com
Whole thread Raw
In response to Is it ever necessary to vacuum a table that only gets inserts/updates?  (Jason Buberel <jason@altosresearch.com>)
Responses Re: Is it ever necessary to vacuum a table that only gets inserts/updates?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jason Buberel
Date:
Subject: Is it ever necessary to vacuum a table that only gets inserts/updates?
Next
From: Yan Chunlu
Date:
Subject: how could duplicate pkey exist in psql?