Re: What is an 'unused item pointer'

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What is an 'unused item pointer'
Date: 2005-09-24 23:19:10
Message-ID: 25138.1127603950@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Jim C. Nasby" <jnasby(at)pervasive(dot)com> writes:
> I can't seem to find info about this in the docs, or on the web.

http://developer.postgresql.org/docs/postgres/storage-page-layout.html

Currently, when a tuple is reclaimed by VACUUM, we just mark its item
pointer as unused (and hence recyclable). I think it might be safe to
decrease pd_lower if there are unused pointers at the end of the page's
pointer array, but we don't currently do that. In any case there could
still be unused pointers embedded within the array.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2005-09-25 00:27:54 Re: What is an 'unused item pointer'
Previous Message Jim C. Nasby 2005-09-24 22:44:47 What is an 'unused item pointer'