Insert only tables and vacuum performance
Joseph Shraibman <jks@selectacast.net>
From: Joseph Shraibman <jks@selectacast.net>
To: pgsql-performance@postgresql.org
Date: 2004-04-29T23:08:23Z
Lists: pgsql-performance
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?