[PERFORM] Insert only tables and vacuum performance

[Joseph Shraibman]

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


Advertising