VACUUM Quesition

Поиск
Список
Период
Сортировка
От Stefan Sturm
Тема VACUUM Quesition
Дата
Msg-id 20040205170839.71DC1D1CB1D@svr1.postgresql.org
обсуждение исходный текст
Ответ на Re: R: slow seqscan after vacuum analize  (Andrew Biagioni <andrew.biagioni@e-greek.net>)
Ответы Re: VACUUM Quesition  (Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>)
Список pgsql-admin
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?

And is there a strategy when to use which vacuum? I think I should do a full
vacuum every night and a vacuum analyze sometimes a day.

Is this OK?

Greetings,
Stefan Sturm



В списке pgsql-admin по дате отправления:

Предыдущее
От: "Edoardo Ceccarelli"
Дата:
Сообщение: R: R: slow seqscan after vacuum analize
Следующее
От: Tom Lane
Дата:
Сообщение: Re: R: R: slow seqscan after vacuum analize