"Craig A. James" <cjames(at)modgraph-usa(dot)com> writes:
> Is there no real-time garbage collection at all in Postgres?
> 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
pgsql-performance by date
|Next:||From: Joshua D. Drake||Date: 2006-11-26 17:47:38|
|Subject: Re: When to vacuum a table?|
|Previous:||From: Michael Simms||Date: 2006-11-26 16:35:52|
|Subject: BUG #2784: Performance serious degrades over a period of a month|