Re: Clarification required: autovacuum and VACUUM command mode

Hi Guillaume,

Thanks for a quick response.

How do I check this? Please clarify.

Regards, Narasimha Murthy
Cell +91 95814 98895, +91-94940 62794 | 040-2347 2025 (O) | x2025 (O)

-----Original Message-----
From: Guillaume Lelarge [mailto:guillaume(at)lelarge(dot)info]
Sent: Friday, May 14, 2010 6:34 PM
To: Narasimha Murthy-VRFX87
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode

Hi,

Le 14/05/2010 14:52, Narasimha Murthy-VRFX87 a écrit :
> [...]
> I need a clarification on auto-vacuum. Appreciate any
> clarification/help.
>
> As explained in page 1093 of postgresql-8.2-US.pdf, 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.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com