Re: Update table performance - Mailing list pgsql-performance

From Michael Stone
Subject Re: Update table performance
Date
Msg-id 20070809131342.GK22785@mathom.us
Whole thread Raw
In response to Re: Update table performance  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: Update table performance  ("Trevor Talbot" <quension@gmail.com>)
List pgsql-performance
On Thu, Aug 09, 2007 at 06:04:09PM +0530, Merlin Moncure wrote:
>keep an eye for the HOT feature which will hopefully make 8.3 that
>will highly reduce the penalty for (small) updates in many cases.

Is there an overview somewhere about how this feature works and what it
is expected to do? There have been a lot of references to it over time,
and it's possible to understand it if you follow list traffic over time,
but starting cold it's hard to know what it is. The name was poorly
chosen as far as google is concerned. :)

Mike Stone

pgsql-performance by date:

Previous
From: Bill Moran
Date:
Subject: Re: When/if to Reindex
Next
From: "Trevor Talbot"
Date:
Subject: Re: Update table performance