Clarification required: autovacuum and VACUUM command mode

From: "Narasimha Murthy-VRFX87" <VRFX87(at)motorola(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Clarification required: autovacuum and VACUUM command mode
Date: 2010-05-14 12:52:04
Message-ID: 58FEF525AF1E664D9503ACDEAC926BBC03BE7D5F@ZMY16EXM66.ds.mot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

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)?

postgresql-8.2-US.pdf manual is available at
http://www.postgresql.org/files/documentation/pdf/8.2/postgresql-8.2-US.
pdf
<http://www.postgresql.org/files/documentation/pdf/8.2/postgresql-8.2-US
.pdf>

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2010-05-14 13:03:42 Re: Clarification required: autovacuum and VACUUM command mode
Previous Message Scott Mead 2010-05-14 10:28:46 Re: Automatic trigger to backup