From: Mindaugas Riauba <mind@bi.lt>
To: pgsql-performance@postgresql.org
Subject: Re: 'Real' auto vacuum?
Date: Wed, 31 Aug 2005 08:17:53 +0300
Message-ID: <00f601c5adeb$56fcb910$f20214ac@bite.lt> (raw)
References: <4314DBE0.9070708@telogis.com>
<200508301558.34697.josh@agliodbs.com>
> > 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.
Some ETA? Since that would be the most welcome addition for us. We
have few very heavily updated databases where table bloat and constant
vacuuming is killing performance.
Mindaugas
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mind@bi.lt
Subject: Re: 'Real' auto vacuum?
In-Reply-To: <00f601c5adeb$56fcb910$f20214ac@bite.lt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox