Re: Autovacuum in the backend - Mailing list pgsql-hackers

From Hans-Jürgen Schönig
Subject Re: Autovacuum in the backend
Date
Msg-id 42B278C0.7050703@cybertec.at
Whole thread Raw
In response to Re: Autovacuum in the backend  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Autovacuum in the backend
Next
From: Greg Stark
Date:
Subject: Re: [PATCHES] Escape handling in strings