Re: Preventing duplicate vacuums?

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Preventing duplicate vacuums?
Дата
Msg-id Pine.LNX.4.44.0402062142430.12927-100000@hosting.commandprompt.com
обсуждение исходный текст
Ответ на Re: Preventing duplicate vacuums?  (Thomas Swan <tswan@idigx.com>)
Список pgsql-hackers
> What about a situation where someone would have lazy vacuums cron'd and 
> it takes longer to complete the vacuum than the interval between 
> vacuums.  You could wind up with an ever increasing queue of vacuums.
> 
> Erroring out with a "vacuum already in progress" might be useful.

I have seen this many times with customers as their traffic on the 
database grows. A simple check would be of great, great use.

Sincerely,

Joshua D. Drake



> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 

-- 
Co-Founder
Command Prompt, Inc.
The wheel's spinning but the hamster's dead



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

Предыдущее
От: Thomas Swan
Дата:
Сообщение: Re: Preventing duplicate vacuums?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: bug in substring???