I have a table that is never updated, only INSERTED into. Is there a way I can prevent vacuum wasting time on this table besides vacuuming each table in the db by itself and omitting this table?

How feasable would it be to have a marker somewhere in pg that is "updated since last vacuum" that would be cleared when vacuum runs, and if set vacuum will ignore that table?

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to