Re: 'Real' auto vacuum?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Ralph Mason <ralph(dot)mason(at)telogis(dot)com>
Subject: Re: 'Real' auto vacuum?
Date: 2005-08-30 22:58:34
Message-ID: 200508301558.34697.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Ralph,

> When a row is orphaned it's added to a list of possibly available rows.
> When a new row is needed the list of possible rows is examined and the
> first one with a transaction id less then the lowest running transaction
> id is chosen to be the new row? These rows can be in a heap so it's
> really fast to find one.

This is the long-term plan. However, it's actually a lot harder than it
sounds. Patches welcome.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ron 2005-08-30 23:02:28 Re: RAID Configuration Sugestion
Previous Message mark 2005-08-30 22:35:19 Re: 'Real' auto vacuum?