> and vacuum takes just a very few seconds a day. I think I recall hearing
on
> this list of it taking a minute or three for databases several gigabytes
in
> size. For some sites this would be tolerable, for others it wouldn't.
It depends more on user activity and number/size of indexes than over all
database size from what I've seen.. In one database I have 20ish tables,
some have 70,000ish records but the whole database isn't very big -- VACUUM
takes a while because of the amount of UPDATE'd and DELETE'd records I have
every day, and the number of indexes (lots!)....
> I'm also interested to hear what the future holds for vacuum. If nothing
else,
> it couldn't hurt postgresql's public relations. :-)
>
> --Wes Sheldahl