Hi Kevin,
Thanks for the clarification.
I have planned to schedule Lazy Vacuum (, not FULL Vacuum) using auto-vacuum daemon.
Another query: I do not want to run Analyze. However, auto-vacuum runs both both VACUUM and ANALYZE. I do not see any
optionto disable running ANALYZE during auto-vacuum. Is there any way to achive this?
Pl clarify.
Regards, Narasimha Murthy
Cell +91 95814 98895, +91-94940 62794 | 040-2347 2025 (O) | x2025 (O)
-----Original Message-----
From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov]
Sent: Friday, May 14, 2010 7:10 PM
To: Narasimha Murthy-VRFX87
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode
"Narasimha Murthy-VRFX87" <VRFX87@motorola.com> wrote:
> Guillaume Lelarge <guillaume@lelarge.info> wrote:
>> Le 14/05/2010 14:52, Narasimha Murthy-VRFX87 a écrit :
>>> VACUUM command works either in plain mode (if we do not specify
>>> FULL) or in FULL mode. When autovacuum is enabled, what mode does it
>>> run the VACUUM command (in plain mode or in FULL mode)?
>>
>> In plain mode.
> How do I check this? Please clarify.
http://www.postgresql.org/docs/8.2/interactive/routine-vacuuming.html#VACUUM-FOR-SPACE-RECOVERY
Since VACUUM FULL is not recommended for routine use, it would hardly make sense to use it for autovacuum. If you want
toconfirm, try selecting from a table while autovacuum is vacuuming it -- since VACUUM FULL locks the table against all
otheruses, the ability to select proves it's not VACUUM FULL.
By the way, I hope you're not considering scheduling regular VACUUM FULL runs against your database. You would wind up
regrettingthat.
If you don't believe that, I recommend that you reread the above-cited section until you're convinced.
-Kevin