"vacuum" and "cluster"

Поиск
Список
Период
Сортировка
От Jimmy Choi
Тема "vacuum" and "cluster"
Дата
Msg-id 5770602b0804160809j6cb5937t4a30858f645e64d3@mail.gmail.com
обсуждение исходный текст
Ответы Re: "vacuum" and "cluster"
Список pgsql-general
Hello,

Does running "cluster" remove the need to run "vacuum"?

I get a feeling that since cluster is already physically reordering
the rows, it may as well remove the dead rows... no?

My second question is, if vacuum is still needed, does it matter
whether I run vacuum first or cluster first?

Here's our current weekly db maintenance routine:

1. vacuum full
2. cluster
3. reindex
4. analyze

Thanks,
Jimmy

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

Предыдущее
От: Dragan Zubac
Дата:
Сообщение: Re: Master-master replication with PostgreSQL
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: Storage sizes for dates/times (documentation bug?)