Re: VACUUM Quesition

Поиск
Список
Период
Сортировка
От Sam Barnett-Cormack
Тема Re: VACUUM Quesition
Дата
Msg-id Pine.LNX.4.50.0402051721300.12789-100000@short.lancs.ac.uk
обсуждение исходный текст
Ответ на VACUUM Quesition  ("Stefan Sturm" <mailling@anrath.info>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: R: R: slow seqscan after vacuum analize
Следующее
От: Ivan Zenzerović
Дата:
Сообщение: Installation procedure