Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Insert only tables and vacuum performance
Date
Msg-id 20619.1083299426@sss.pgh.pa.us
Whole thread Raw
In response to Insert only tables and vacuum performance  (Joseph Shraibman <jks@selectacast.net>)
Responses Re: Insert only tables and vacuum performance
List pgsql-performance
Tree view 
Joseph Shraibman <jks@selectacast.net> writes:
> I have a table that is never updated, only INSERTED into. Is there a way
> I can prevent vacuum wasting time on this table

What makes you think vacuum is wasting much time on this table?  AFAICS
it will only update any unfixed hint bits ...

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: why can't 2 indexes be used at once?
Next
From: Dennis Bjorklund
Date:
Subject: Re: planner/optimizer question