Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group