>>>>> "Kjetil" == Kjetil Torgrim Homme <kjetilho@???> writes:
Kjetil> On Wed, 2006-09-20 at 08:44 +0100, Dave Evans wrote:
Kjetil> Tom's announcement :), but we've had problems with vacuum
Kjetil> being unable to do enough garbage collection so the
Kjetil> database was growing steadily no matter what. this was in
Kjetil> PostgreSQL 7.x, we believe it is fixed in 8.1.
>> Actually it's worse than that: if you don't vacuum, eventually
>> you WILL lose data; old rows will just disappear. Been there,
>> done that, not pretty. Don't forget to vacuum.
Kjetil> never seen that, which PostgreSQL version was that?
It can affect any version, see :-
http://www.postgresql.org/docs/8.1/static/maintenance.html#VACUUM-FOR-WRAPAROUND
Sincerely,
Adrian Phillips
--
Who really wrote the works of William Shakespeare ?
http://www.pbs.org/wgbh/pages/frontline/shakespeare/
