I'm running Drupal 7 with PostgreSQL as a Q&A (with a lot of nodes inserts/updates and several contrib modules). Do you, dba admins, recommand any particular pgsql vacuum policy on particular default tables ?
Any recent version of Postgres will have an autovacuum process. Let the autovacuum do its work - It is very good at its job, and will run in such a way as to not interfere with normal use of the database.
If you make a huge number of changes you may want to run a
You can read more about tuning autovacuum (and times when you might need/want to manually VACUUM your database) in the Postgres documentation.