From: | Frank Bax <fbax(at)sympatico(dot)ca> |
---|---|
To: | PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Vacuuming |
Date: | 2010-02-13 17:53:18 |
Message-ID: | BLU0-SMTP59BA3D9EDFBF8BF6315188AC4C0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
APseudoUtopia wrote:
> 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
>
I can't seem to find how to start autovacuum daemon?
Once running how can I monitor its effect?
From | Date | Subject | |
---|---|---|---|
Next Message | Mladen Gogala | 2010-02-13 19:40:56 | Re: Vacuuming |
Previous Message | APseudoUtopia | 2010-02-13 16:42:37 | Re: Vacuuming |