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

Re: When to vacuum a table?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Craig A(dot) James" <cjames(at)modgraph-usa(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: When to vacuum a table?
Date: 2006-11-26 17:06:06
Message-ID: 19249.1164560766@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"Craig A. James" <cjames(at)modgraph-usa(dot)com> writes:
> Is there no real-time garbage collection at all in Postgres?

No.

> And if so, is this because nobody has had time to implement garbage
> collection, or for a more fundamental reason, or because VACUUM is
> seen as sufficient?

If you really want to know, read the mountains of (mostly) junk that
have been written about replacing VACUUM in pgsql-hackers.  The short
answer (with apologies to Winston Churchill) is that VACUUM is the worst
solution, except for all the others that have been suggested.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2006-11-26 17:47:38
Subject: Re: When to vacuum a table?
Previous:From: Michael SimmsDate: 2006-11-26 16:35:52
Subject: BUG #2784: Performance serious degrades over a period of a month

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