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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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...
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2007-02-20 16:02:41 | Re: New feature request: FlashBack Query |
Previous Message | Rod Taylor | 2007-02-20 15:42:28 | Re: New feature request: FlashBack Query |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2007-02-20 15:54:04 | Re: correct format for date, time, timestamp for XML functionality |
Previous Message | Pavel Stehule | 2007-02-20 15:32:28 | Re: correct format for date, time, timestamp for XML functionality |