Postgres Pro
Downloads
Home   >   mailing lists

Insert only tables and vacuum performance - Mailing list pgsql-performance

From Joseph Shraibman
Subject Insert only tables and vacuum performance
Date
Msg-id c6s1t4$1au1$1@news.hub.org
Whole thread Raw
Responses Re: Insert only tables and vacuum performance
Re: Insert only tables and vacuum performance
List pgsql-performance
Tree view 
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?

pgsql-performance by date:

Previous
From: Joseph Shraibman
Date:
Subject: analyzer/planner and clustered rows
Next
From: Tom Lane
Date:
Subject: Re: planner/optimizer question