Re: Re: VACUUM and 24/7 database operation

Поиск
Список
Период
Сортировка
От Steve Wolfe
Тема Re: Re: VACUUM and 24/7 database operation
Дата
Msg-id 021a01c0857e$781528c0$50824e40@iboats.com
обсуждение исходный текст
Ответ на VACUUM and 24/7 database operation  (Thomas.Favier@accelance.fr)
Ответы Re: Re: VACUUM and 24/7 database operation
Список pgsql-general
> Shouldn't it be possible to build vacuum as an ongoing internal PG
process,
> instead of a seperate operation? How does Oracle byepass this? Must be
some
> way that can be implemented.

  Well, here's what it comes down to:  Do you want updates to happen
quickly, and vacuum when load is low, or do you want updates to be slow all
the time?  I suppose that there are some sites that can't find two minutes
per day when updates will block (not selects), but I imagine they're very
few.

steve



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

Предыдущее
От: Alfred Perlstein
Дата:
Сообщение: Re: Re: VACUUM and 24/7 database operation
Следующее
От: "Martin A. Marques"
Дата:
Сообщение: Re: Looking for info on Solaris 7 (SPARC) specific considerations