Re: Autovacuum in the backend
От | Rod Taylor |
---|---|
Тема | Re: Autovacuum in the backend |
Дата | |
Msg-id | 1118898857.78366.106.camel@home обсуждение исходный текст |
Ответ на | Re: Autovacuum in the backend ("Matthew T. O'Connor" <matthew@zeut.net>) |
Список | pgsql-hackers |
On Thu, 2005-06-16 at 00:44 -0400, Matthew T. O'Connor wrote: > Joshua D. Drake wrote: > > > 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. > > * Eliminates newbie confusion Ignore everything else. This one is the clincher. Someone doing serious database work is going to read the docs to find out about backup / restore processes and basic tuning. They'll run across the disable switch for autovacuum soon enough. The jack of all trades IT guy who is running some minor work but doesn't know much about databases in general won't have as many hurdles to climb. Besides, vacuum off by default possibly makes for huge files and takes forever to reclaim space (cluster, vacuum full, etc.). Vacuum on by default means worst case they turn it off and instantly their IO load decreases. --
В списке pgsql-hackers по дате отправления: