Re: reserving space in a rec for future update

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: reserving space in a rec for future update
Date: 2007-11-14 16:54:47
Message-ID: 20071114165447.GV16041@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 14, 2007 at 11:44:55AM -0500, Mike Charnoky wrote:
> In this usage scenario, doesn't the new HOT (heap only tuples) feature
> of PG8.3 help, in terms of the DB requiring less VACUUM maintenance?

It should, yes. We'll probably know more once 8.3 is in the field. For new
work, though, I would certainly suggest trying this on 8.3. I know that's
the _point_ of the feature. But if you've already got an application you
need to field today, doing it on a beta is risky.

A

--
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2007-11-14 17:02:48 Re: reserving space in a rec for future update
Previous Message Andrew Sullivan 2007-11-14 16:53:26 Re: reserving space in a rec for future update