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

Re: When does VACUUM FULL not clean out all deleted data?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: James Cloos <cloos(at)jhcloos(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: When does VACUUM FULL not clean out all deleted data?
Date: 2008-01-04 16:26:25
Message-ID: 477E5E31.1040202@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-admin
James Cloos wrote:
>>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> 
>>> Why was the db using that extra five plus gigs?
> 
> Tom> Smells like a hadn't-been-vacuuming-often-enough problem.
> 
> Sorry, I forgot to mention:  autovacuum was enabled and I also ran
> this script every night via cron:
> 
> #!/bin/bash
> FULL=''
> test $(date +%w) -eq 0 && FULL='FULL'
> exec psql -U dbm -c "VACUUM ${FULL} VERBOSE ANALYZE" dbm
> 
> The app at least felt faster with the daily vacuum, even though
> autovacuum was running.  I don't have a good explanation for that,
> either.

Autovacuum by default won't do enough work for many production 
databases. You still have to configure it.

Joshua D. Drake


In response to

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-01-04 16:33:42
Subject: Re: Need some info on Postgresql
Previous:From: Usama DarDate: 2008-01-04 16:18:21
Subject: Re: Need source for Solaris 9

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