Re: Update table performance - Mailing list pgsql-performance

From Trevor Talbot
Subject Re: Update table performance
Date
Msg-id 90bce5730708090641u2f38a592j6b6812650c6b4a40@mail.gmail.com
Whole thread Raw
In response to Re: Update table performance  (Michael Stone <mstone+postgres@mathom.us>)
List pgsql-performance
On 8/9/07, Michael Stone <mstone+postgres@mathom.us> wrote:
> 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. :)

This is what I found when I went looking for info earlier:
http://archives.postgresql.org/pgsql-patches/2007-07/msg00142.php
http://archives.postgresql.org/pgsql-patches/2007-07/msg00360.php

pgsql-performance by date:

Previous
From: Michael Stone
Date:
Subject: Re: Update table performance
Next
From: "Steven Flatt"
Date:
Subject: Re: When/if to Reindex