Skip site navigation (1) Skip section navigation (2)

Re: When to vacuum a table?

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: When to vacuum a table?
Date: 2006-11-26 14:33:52
Message-ID: 20061126143352.GA17832@phlogiston.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)crankycanuck(dot)ca
The whole tendency of modern prose is away from concreteness.
		--George Orwell

In response to

pgsql-performance by date

Next:From: Craig A. JamesDate: 2006-11-26 16:26:52
Subject: Re: When to vacuum a table?
Previous:From: Rod TaylorDate: 2006-11-26 14:24:29
Subject: Re: When to vacuum a table?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group