Re: Resurrecting per-page cleaner for btree

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-patches(at)postgresql(dot)org, teramoto(dot)junji(at)lab(dot)ntt(dot)co(dot)jp
Subject: Re: Resurrecting per-page cleaner for btree
Date: 2006-07-13 20:59:38
Message-ID: 1152824378.2654.161.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Thu, 2006-07-13 at 10:49 +0900, ITAGAKI Takahiro wrote:
> This is a revised patch originated by Junji TERAMOTO for HEAD.
> [BTree vacuum before page splitting]
> http://archives.postgresql.org/pgsql-patches/2006-01/msg00301.php
>
> I think we can resurrect his idea because we will scan btree pages
> at-atime now; the missing-restarting-point problem went away.
>
> Have I missed something? Comments welcome.

The new locking system does allow this now.

So this is an option for us, AFAICS.

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2006-07-13 21:01:35 Re: monolithic distro
Previous Message Lukas Kahwe Smith 2006-07-13 20:55:54 Re: monolithic distro

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2006-07-13 21:02:52 Re: 8.2 features?
Previous Message Joachim Wieland 2006-07-13 20:33:51 Time zone definitions to config files