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

Re: Vacuuming

From: APseudoUtopia <apseudoutopia(at)gmail(dot)com>
To: peter(at)vfemail(dot)net
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Vacuuming
Date: 2010-02-13 16:42:37
Message-ID: 27ade5281002130842m3c98cb16t925d38d9d8760860@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Fri, Feb 12, 2010 at 7:32 PM,  <peter(at)vfemail(dot)net> wrote:
>
> There's a script running on my server hosting a PostgreSQL database that does some type of vacuuming routine every Friday at 5:00 p.m.  Specifically, the script executes this command:
>
>     psql -d database_name -c "vacuum full verbose"
>
> and e-mails the verbose output to me.  Today's report today contains about 900,000 characters.
>
> I don't event know where to begin reading that report, interpreting what it's telling me, determining what's important, or ascertaining what's routing and unimportant.
>
> Can anybody give me any guidance or point me to a document that I should read to understand what the PostgreSQL vacuum does and why this is an important function and how to decipher the verbose output?
>

You should never run VACUUM FULL on a regular basis. In fact, it's
recommended never to use FULL.
See: http://wiki.postgresql.org/wiki/VACUUM_FULL

In response to

  • Vacuuming at 2010-02-13 00:32:58 from peter

Responses

pgsql-novice by date

Next:From: Frank BaxDate: 2010-02-13 17:53:18
Subject: Re: Vacuuming
Previous:From: peterDate: 2010-02-13 00:32:58
Subject: Vacuuming

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