Re: [PERFORM] Vacuum becomes slow

2005-06-30 Thread Tom Lane
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 ove

[PERFORM] Vacuum becomes slow

2005-06-30 Thread Martin Lesser
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.