Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group