> As far as getting into base postgresql distro. I don't mind it rewriting but I
> have some reservations.
> 1) As it is postgresql source code is huge. Adding functions to it which
> directly taps into it's nervous system e.g. cache, would take far more time to
> perfect in all conditions.
It doesn't have to make its way into the postgresql daemon itself -- in fact since some people like tuning the
vacuuming,it makes more sense to make this a daemon. No, my suggestion is simple that some sort of auto-vacuumer be
compiledas a stand-alone app and included in the standard postgresql tar.gz file, and the install instructions
recommendthe site adding it as a cron job.
On linux, it'd be good if the RPM install it automatically (or else it ran as a mostly-asleep daemon) because so many
ofthe Linux/Postgresql users we see have just no clue about Postgresql, and no intention of reading anything.
Just an FYI, a message I received today from the postmaster at a major telco about their postgresql experience:
> We have experienced some problems but they have generally
> cleared up after a database vacuum. However, sometimes I
> have found that the vacuum itself (especially a vacuum analyze)
> will go into the CPU consumption loop.
-john