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

Re: [HACKERS] HOT WIP Patch - version 2

From: mark(at)mark(dot)mielke(dot)cc
To: Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Hannu Krosing <hannu(at)skype(dot)net>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>,pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] HOT WIP Patch - version 2
Date: 2007-02-20 15:47:43
Message-ID: 20070220154743.GA2000@mark.mielke.cc (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Tue, Feb 20, 2007 at 08:31:45PM +0530, Pavan Deolasee wrote:
> I see your point, but as you mentioned do we really care ? The chain
> needs to be broken so that the intermediate DEAD tuples can be
> vacuumed. We can't vacuum them normally because they could
> be a part of live HOT-update chain. Resetting the HOT-updated
> status of the root tuple helps to mark the index entry LP_DELETE
> once the entire HOT-update chain is dead.
> ...

For some reason this paragraph raised a query in my mind. Will we
be able to toggle this new "hot update" code at configure time, so
that we can measure what sort of effect this change has once it is
complete?

Even if only during the early testing cycles for the next release, I
think it would be useful.

Cheers,
mark

-- 
mark(at)mielke(dot)cc / markm(at)ncf(dot)ca / markm(at)nortel(dot)com     __________________________
.  .  _  ._  . .   .__    .  . ._. .__ .   . . .__  | Neighbourhood Coder
|\/| |_| |_| |/    |_     |\/|  |  |_  |   |/  |_   | 
|  | | | | \ | \   |__ .  |  | .|. |__ |__ | \ |__  | Ottawa, Ontario, Canada

  One ring to rule them all, one ring to find them, one ring to bring them all
                       and in the darkness bind them...

                           http://mark.mielke.cc/


In response to

pgsql-hackers by date

Next:From: Hannu KrosingDate: 2007-02-20 16:02:41
Subject: Re: New feature request: FlashBack Query
Previous:From: Rod TaylorDate: 2007-02-20 15:42:28
Subject: Re: New feature request: FlashBack Query

pgsql-patches by date

Next:From: Andrew DunstanDate: 2007-02-20 15:54:04
Subject: Re: correct format for date, time, timestamp for XML functionality
Previous:From: Pavel StehuleDate: 2007-02-20 15:32:28
Subject: Re: correct format for date, time, timestamp for XML functionality

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