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@xxxxxxxxxxxx] Sent: Friday, May 14, 2010 6:34 PM To: Narasimha Murthy-VRFX87 Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin