Description of problem: The postgresql install in Fedora and RHEL does not start database vacuuming of any kind. IMHO it would be a good idea to have pg_autovacuum running by default, configured to analyse and vacuum the tables after reasonable intervals. Reclaiming disk space is the one area I can think of where mysql is currently better than postgres, it would be nice to close the gap here ;)
I think this would probably be reasonable to do in PG 8.1, where autovacuum is built into the core database. I don't have enough confidence in the external contrib version of autovacuum to want to turn it on by default.