RE: [Bacula-users] DB Vacuuming in Postgres

2006-02-23 Thread Magnus Hagander
> > Just a few quick questions before we start testing. > > > > Is this necessary to keep the DB size at a norm? > > I found it very necessary when using Postgres 7.3.4. It > needs a full vacuum every week for me. Vacuum is necessary in all PostgreSQL versions, if you ever do UPDATEs or DELETE

Re: [Bacula-users] DB Vacuuming in Postgres

2006-02-22 Thread Martin Simmons
> On Wed, 22 Feb 2006 13:30:58 -0500, William Reid <[EMAIL PROTECTED]> said: > > Just a few quick questions before we start testing. > > Is this necessary to keep the DB size at a norm? I found it very necessary when using Postgres 7.3.4. It needs a full vacuum every week for me. > Will i

Re: [Bacula-users] DB Vacuuming in Postgres

2006-02-22 Thread Dan Langille
On 22 Feb 2006 at 13:30, William Reid wrote: > Just a few quick questions before we start testing. > > Is this necessary to keep the DB size at a norm? It reclaims space that would otherwise be unused in future. > Will it hurt anything? Shouldn't. > Has anyone setup a cronjob to handle this p