Re: Insert only tables and vacuum performance

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Insert only tables and vacuum performance
Date: 2004-04-30 00:44:16
Message-ID: 1083285855.30065.462.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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 anyway,
how do you handle a rolled back insert?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joseph Shraibman 2004-04-30 00:53:21 Re: Insert only tables and vacuum performance
Previous Message Joseph Shraibman 2004-04-29 23:24:40 Re: Insert only tables and vacuum performance