a vacuum thread is not the answer

From: mlw <markw(at)mohawksoft(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: a vacuum thread is not the answer
Date: 2002-03-07 15:15:43
Message-ID: 3C87841F.3E580961@mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I was just toying around with things, and you know, running vacuum in the
background doesn't work. It slows things down too much.

The worst case senario is when one does this:

update accounts set abalance = abalance + 1 ;

This takes forever to run and doubles the size of the table.

Is there a way that a separate thread managing the freelist can perform a "per
row" vacuum concurrently? Maybe I am stating the problem incorrectly, but we
need to be able to recover rows already in memory for performance.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fernando Nasser 2002-03-07 15:24:45 Current cvs source regression: create_function_1.out
Previous Message Tom Lane 2002-03-07 15:14:39 Re: Small fix for _equalValue()