Re: HOT - preliminary results - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Re: HOT - preliminary results
Date
Msg-id 45E707D4.3060409@enterprisedb.com
Whole thread Raw
In response to Re: HOT - preliminary results  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: HOT - preliminary results  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-hackers
Merlin Moncure wrote:> On 3/1/07, Pavan Deolasee <pavan.deolasee@enterprisedb.com> wrote:>>> seems pretty solid except
forone 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



pgsql-hackers by date:

Previous
From: Zoltan Boszormenyi
Date:
Subject: Re: Is there a way to run heap_insert() AFTER ExecInsertIndexTuples() ?
Next
From: Jonathan Scher
Date:
Subject: Re: CLUSTER, using SHARE UPDATE EXCLUSIVE lock?