Insert only tables and vacuum performance

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Insert only tables and vacuum performance
Date: 2004-04-29 23:08:23
Message-ID: c6s1t4$1au1$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joseph Shraibman 2004-04-29 23:09:09 analyzer/planner and clustered rows
Previous Message Gary Doades 2004-04-29 23:01:10 Re: planner/optimizer question