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

Re: When to vacuum a table?

From: "Craig A(dot) James" <cjames(at)modgraph-usa(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: When to vacuum a table?
Date: 2006-11-26 16:26:52
Message-ID: 4569C04C.8090503@modgraph-usa.com (view raw or flat)
Thread:
Lists: pgsql-performance
Rod Taylor wrote:
>> Just a minor clarification here: INSERT does not create dead rows, only
>> UPDATE and DELETE do. Thus, if you only insert rows, you do not need to
>> vacuum (although you probably need to analyze).

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?

I'm just curious ... Vacuum has always seemed to me like an ugly wart on the pretty face of Postgres.  (I say this even though I implemented an identical solution on a non-relational chemistry database system a long time ago.  I didn't like it then, either.) 

Craig

In response to

Responses

pgsql-performance by date

Next:From: Michael SimmsDate: 2006-11-26 16:35:52
Subject: BUG #2784: Performance serious degrades over a period of a month
Previous:From: Andrew SullivanDate: 2006-11-26 14:33:52
Subject: Re: When to vacuum a table?

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