Re: HOT - preliminary results

From: "Pavan Deolasee" <pavan(dot)deolasee(at)enterprisedb(dot)com>
To: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: HOT - preliminary results
Date: 2007-03-01 17:05:24
Message-ID: 45E707D4.3060409@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Merlin Moncure wrote:
> On 3/1/07, Pavan Deolasee <pavan(dot)deolasee(at)enterprisedb(dot)com> wrote:
>>
> seems pretty solid except for one possible problem...at one point when
> I dropped then later added the index on 'abalance', I got spammed
> 'WARNING: found a HOT-updated tuple' from psql prompt.

Thats intentional. We don't yet support CREATE INDEX on a HOT-updated
table. This is one of the major unfinished TODO items before we can
consider patch feature complete. I have left the warning to catch
this case till then.

Thanks,
Pavan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonathan Scher 2007-03-01 17:23:37 Re: CLUSTER, using SHARE UPDATE EXCLUSIVE lock?
Previous Message Zoltan Boszormenyi 2007-03-01 16:58:52 Re: Is there a way to run heap_insert() AFTER ExecInsertIndexTuples() ?