Re: VACUUM Quesition - Mailing list pgsql-admin

From Sam Barnett-Cormack
Subject Re: VACUUM Quesition
Date
Msg-id Pine.LNX.4.50.0402051721300.12789-100000@short.lancs.ac.uk
Whole thread Raw
In response to VACUUM Quesition  ("Stefan Sturm" <mailling@anrath.info>)
List pgsql-admin
On Thu, 5 Feb 2004, Stefan Sturm wrote:

> Hello,
>
> I have a question about vaccum. There are thre Version of vaccums:
> 1.) plain vacuum
> 2.) vacuum analyze
> 3.) full vacuum
>
> Is it right that a vacuum analyze includes the plain vacuum and the full
> vacuum includes the vacuum analyze? And which vacuum locks the tables?

'full' is an option to vacuum, essentially, as is 'analyze', so there
are four variants (ignoring the freeze option):

vacuum
vacuum analyze
vacuum full
vacuum full analyze

It's all pretty obvious from there.

--

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: R: R: slow seqscan after vacuum analize
Next
From: Ivan Zenzerović
Date:
Subject: Installation procedure