Re: No vacuum for insert-only database? - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: No vacuum for insert-only database?
Date
Msg-id 20060313150949.GK8274@surnet.cl
Whole thread Raw
In response to No vacuum for insert-only database?  ("Craig A. James" <cjames@modgraph-usa.com>)
Responses Re: No vacuum for insert-only database?  ("Craig A. James" <cjames@modgraph-usa.com>)
List pgsql-performance
Craig A. James wrote:
> If I only insert data into a table, never update or delete, then I should
> never have to vacuum it.  Is that correct?

You still need to vacuum eventually, to avoid transaction Id wraparound
issues.  But not as often.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-performance by date:

Previous
From: "Craig A. James"
Date:
Subject: No vacuum for insert-only database?
Next
From: "Craig A. James"
Date:
Subject: Re: No vacuum for insert-only database?