pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Guillaume Lelarge <guillaume@lelarge.info>
To: Narasimha Murthy-VRFX87 <VRFX87@motorola.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Clarification required: autovacuum and VACUUM command mode
Date: Fri, 14 May 2010 15:03:42 +0200
Message-ID: <4BED4A2E.2090507@lelarge.info> (raw)
In-Reply-To: <58FEF525AF1E664D9503ACDEAC926BBC03BE7D5F@ZMY16EXM66.ds.mot.com>
References: <58FEF525AF1E664D9503ACDEAC926BBC03BE7D5F@ZMY16EXM66.ds.mot.com>

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



view thread (12+ messages)  latest in thread

Message-ID: <4BED4A2E.2090507@lelarge.info>
Permalink:  ../4BED4A2E.2090507@lelarge.info/
Also on:    postgresql.org/message-id/4BED4A2E.2090507@lelarge.info

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: guillaume@lelarge.info, VRFX87@motorola.com
  Subject: Re: Clarification required: autovacuum and VACUUM command mode
  In-Reply-To: <4BED4A2E.2090507@lelarge.info>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox