| 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 | Resend email |
| 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
| 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? |
| 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. |