Re: Vacuum and Transactions

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DAZ SD
Тема Re: Vacuum and Transactions
Дата
Msg-id E1539E0ED7043848906A8FF995BDA5797EFEA4@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Vacuum and Transactions  (Rod Taylor <pg@rbt.ca>)
Список pgsql-hackers
> > Is it reasonable to cancel and restart the vacuum process
periodically
> > (say every 12 hours) until it manages to complete the work? It takes

> > about 2 hours to do the table scan, and should get in about 10 hours

> > of index work each round.

If we started the vacuum with the indexes, remembered a lowest xid per
index,
we could then vacuum the heap up to the lowest of those xids, no ?
We could then also vacuum each index separately.

Andreas


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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: Vacuum and Transactions
Следующее
От: Philip Yarra
Дата:
Сообщение: Slony RPM issue