On Wed, 2006-09-20 at 08:44 +0100, Dave Evans wrote: > On Wed, Sep 20, 2006 at 09:30:44AM +0200, Tom Kistner wrote: > > Larry is probably right. At least I don't remember doing anything > > related to a "Vacuum" in the postgres SQL stubs (maybe this is the > > equivalent of MySQLs "optimize table"?).
vacuum is periodic maintenance. we don't use exilog (we developed our own quite similar solution just weeks before Tom's announcement :), but we've had problems with vacuum being unable to do enough garbage collection so the database was growing steadily no matter what. this was in 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. never seen that, which PostgreSQL version was that? -- Kjetil T. -- ## 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/
