Hi,
the time needed for a daily VACUUM on a table with about 28 mio records
increases from day to day. What's the best way to avoid this? A full
vacuum will probably take too much time, are there other ways to keep
vacuum performant?
The database was updated to postgres-8.0 on Jun 04 this year.
Martin Lesser [EMAIL PROTECTED] writes:
the time needed for a daily VACUUM on a table with about 28 mio records
increases from day to day.
My guess is that the original timings were artificially low because the
indexes were in nearly perfect physical order, and as that condition
degrades over
