Postgres Pro
Downloads
Home   >   mailing lists

Re: When to vacuum a table? - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: When to vacuum a table?
Date
Msg-id 20061126143352.GA17832@phlogiston.dyndns.org
Whole thread Raw
In response to Re: When to vacuum a table?  (Rod Taylor <rod.taylor@gmail.com>)
List pgsql-performance
Tree view 
On Sun, Nov 26, 2006 at 09:24:29AM -0500, Rod Taylor wrote:
> attempt and fail a large number of insert transactions then you will
> still need to vacuum.

And you still need to vacuum an insert-only table sometimes, because
of the system-wide vacuum requirement.

A


--
Andrew Sullivan  | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.
        --George Orwell

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: When to vacuum a table?
Next
From: "Craig A. James"
Date:
Subject: Re: When to vacuum a table?