Re: Autovacuum in the backend

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Autovacuum in the backend
Дата
Msg-id 42B2752B.6090402@commandprompt.com
обсуждение исходный текст
Ответ на Re: Autovacuum in the backend  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Autovacuum in the backend  ("Matthew T. O'Connor" <matthew@zeut.net>)
Список pgsql-hackers
Josh Berkus wrote:
> Josh,
> 
> 
>>Just my own two cents. First I am not knocking the work that has been on
>>autovacuum. I am sure that it was a leap on its own to get it to work.
>>However I will say that I just don't see the reason for it.
> 
> 
> I've personally seen at least a dozen user requests for "autovacuum in the 
> backend", and had this conversation about 1,100 times:
> 
> NB: "After a week, my database got really slow."
> Me: "How often are you running VACUUM ANALYZE?"
> NB: "Running what?"

Can't argue that except... RTFM ;). I am not saying it doesn't have a 
validity. I am just saying that if you actually pay attention to 
PostgreSQL and maintain it, you don't need it ;)

Sincerely,

Joshua D. Drake


> 



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

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: [PATCHES] Escape handling in strings
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Autovacuum in the backend