- For tables that receive only INSERTs, schedule a regular VACUUM with "cron" or similar. Unfortunately, PostgreSQL isn't very smart about vacuuming insert-only tables.
What is the need to vacuum on an insert only table? Does that just maintain the freespace map?