On Sat, 2003-08-09 at 21:25, Christopher Browne wrote: > In 7.3 and 7.4, the "contrib" application, pg_autovacuum can do the > trick, vacuuming anything that reaches thresholds of > inserts/deletes/updates, and do so more or less as often as necessary.
Actually pg_autovacuum is not included with 7.3, but works just fine once you get it compiled. > If you haven't got a cron job looking something like: > > 0 0 * * * * vacuumdb -a -z > /dev/null 2> /dev/null > > then you should probably add that, at least. might be better to have it only vacuum a few specific tables that cause most of your problems. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
