Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6887B9FB5A9 for ; Tue, 23 Jan 2007 06:50:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 54651-07 for ; Tue, 23 Jan 2007 06:49:55 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.185]) by postgresql.org (Postfix) with ESMTP id CACC89FB298 for ; Tue, 23 Jan 2007 06:49:57 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so186070nfb for ; Tue, 23 Jan 2007 02:49:56 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=S8jjmCaA5F2ivlu72MITZ7zOGGqCaEvzvgNkCMmWvDcNQ5v1brnaxo0wEf0RNlqTIK0/VLf0sWDwgrJ3IJh/IzVJUaqS3sKRM6oX3wjjUTsbCX6vdwywE3n4iWsSLk7HgtyaucCoLkqX4YNJ5tpFsgEq/sPjFeVCKr3YsDzg7PY= Received: by 10.48.210.20 with SMTP id i20mr806588nfg.1169549395901; Tue, 23 Jan 2007 02:49:55 -0800 (PST) Received: from ?192.168.1.34? ( [81.107.201.197]) by mx.google.com with ESMTP id m16sm2032514nfc.2007.01.23.02.49.53; Tue, 23 Jan 2007 02:49:53 -0800 (PST) Message-ID: <45B5E848.4060102@enterprisedb.com> Date: Tue, 23 Jan 2007 10:49:44 +0000 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.8 (X11/20061116) MIME-Version: 1.0 To: Pavan Deolasee CC: ITAGAKI Takahiro , Martijn van Oosterhout , pgsql-hackers@postgresql.org Subject: Re: Free space management within heap page References: <20070123084846.GC19527@svana.org> <2e78013d0701230103y1d587db9q6733adca0ca92ca0@mail.gmail.com> <20070123181802.55E1.ITAGAKI.TAKAHIRO@oss.ntt.co.jp> <45B5DEBF.3090200@enterprisedb.com> <2e78013d0701230230n4643a30ao91f0001854154fc2@mail.gmail.com> In-Reply-To: <2e78013d0701230230n4643a30ao91f0001854154fc2@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/1045 X-Sequence-Number: 96946 Pavan Deolasee wrote: > I thought that we can not reclaim the line pointers unless we remove the > corresponding index entries as well. Isn't that the case ? If so, how would > we reclaim the line pointers after the last used one ? There might be index pointers to dead line pointers in the proposed truncation scheme, so those can't be reclaimed, but after the index pointers are removed and the line pointers are unused like they are today, they could be reclaimed. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com