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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

Next:From: Tom LaneDate: 2001-07-07 19:46:42
Subject: Re: Async PQgetResult() question.
Previous:From: Matthew HagertyDate: 2001-07-07 19:02:30
Subject: Re: Async PQgetResult() question.

pgsql-general by date

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

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