>>>>> "Kjetil" == Kjetil Torgrim Homme <[EMAIL PROTECTED]> 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/

-- 
## List details at http://www.exim.org/mailman/listinfo/exim-users 
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://www.exim.org/eximwiki/

Reply via email to