Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group