Re: Insert only tables and vacuum performance

Rod Taylor wrote:
>>Or even better an offset into the datatable for the earliest deleted 
>>row, so if you have a table where you update the row shortly after 
>>insert and then never touch it vacuum can skip most of the table 
>>(inserts are done at the end of the table, right?)
> 
> 
> Inserts are done at the end of the table as a last resort.

But if most of the table is never updated then the inserts would tend to 
be at the end, right?

> But anyway,
> how do you handle a rolled back insert?
> 
It is considered like a deleted row to be vacuumed.