Re: Autovacuum in the backend

Поиск
Список
Период
Сортировка
От Hans-Jürgen Schönig
Тема Re: Autovacuum in the backend
Дата
Msg-id 42B278C0.7050703@cybertec.at
обсуждение исходный текст
Ответ на Re: Autovacuum in the backend  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-hackers
>> * Reduces the total amount of time the system spends vacuuming since 
>> it only vacuums when needed.
> 
> 
> Can be easily done with cron.
> 
>> * Keeps stats up-to-date automatically
> 
> 
> Which can be done with cron
> 
>> * Eliminates newbie confusion
> 
> 
> RTFM
> 
>> * Eliminates one of the criticisms that the public has against 
>> PostgreSQL (justifed or not)
> 
> 
> Agreed.


I few weeks ago I have set up a database with more than 1.800 tables 
(some complex business thing). inventing a clever cron-vacuum strategy 
is almost impossible (or at least very painful). there should be a 
mechanism (fortunately there is pg_autovacuum) to make this a bit more 
practical.

in case of small databases this is not an issue.
small is always simple. complex and large are the major challenges.
best regards,
    hans


-- 
Cybertec Geschwinde u Schoenig
Schoengrabern 134, A-2020 Hollabrunn, Austria
Tel: +43/664/393 39 74
www.cybertec.at, www.postgresql.at



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

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