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

From Joseph Shraibman
Subject Re: Insert only tables and vacuum performance
Date
Msg-id 4091EAD8.4020503@selectacast.net
Whole thread Raw
In response to Re: Insert only tables and vacuum performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Insert only tables and vacuum performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tom Lane wrote:
> 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

INFO:  "elog": found 0 removable, 12869411 nonremovable row versions in
196195 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 5 unused item pointers.
0 pages are entirely empty.
CPU 31.61s/4.53u sec elapsed 1096.83 sec.

It took 1096.83 seconds, and what did it accomplish?  And what are hint
bits?

pgsql-performance by date:

Previous
From: Dennis Bjorklund
Date:
Subject: Re: planner/optimizer question
Next
From: "Gary Doades"
Date:
Subject: Re: planner/optimizer question