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.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Reply via email to