Re: Database-wide VACUUM ANALYZE

Поиск
Список
Период
Сортировка
От Steven Flatt
Тема Re: Database-wide VACUUM ANALYZE
Дата
Msg-id 357fa7590706211337i55e9b20nea5a1bd4c5e41268@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Database-wide VACUUM ANALYZE  (Bill Moran <wmoran@collaborativefusion.com>)
Ответы Re: Database-wide VACUUM ANALYZE  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Database-wide VACUUM ANALYZE  (Jim Nasby <decibel@decibel.org>)
Список pgsql-performance
Thanks everyone.  It appears that we had hacked the 502.pgsql script for our 8.1 build to disable the daily vacuum.  I was not aware of this when building and upgrading to 8.2.
 
So it looks like for the past two weeks, that 36 hour db-wide vacuum has been running every 24 hours.  Good for it for being reasonably non-intrusive and going unnoticed until now. :)
 
Although apparently not related anymore, I still think it was a good move to change autovacuum_freeze_max_age from 200 million to 2 billion.
 
Steve
 

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

Предыдущее
От: "Steven Flatt"
Дата:
Сообщение: Re: Very long SQL strings
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Very long SQL strings