Re: Re: [GENERAL] Vacuum and Transactions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: [GENERAL] Vacuum and Transactions
Date: 2001-07-07 19:15:18
Message-ID: 29021.994533318@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-general pgsql-hackers

Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> writes:
> Would 7.2 maintain performance when updating a row repeatedly (update,
> commit)?

You'll still need to VACUUM to get rid of the obsoleted versions of the
row. The point of the planned 7.2 changes is to make VACUUM cheap and
nonintrusive enough so that you can run it frequently on tables that are
seeing continual updates.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marek Pętlicki 2001-07-07 20:04:12 Re: Bad news for Open Source databases, acording to survey
Previous Message Dr. Evil 2001-07-07 18:30:13 RedHat Open Database?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-07-07 19:46:42 Re: Async PQgetResult() question.
Previous Message Matthew Hagerty 2001-07-07 19:02:30 Re: Async PQgetResult() question.