Re: What is an 'unused item pointer' - Mailing list pgsql-general

From Tom Lane
Subject Re: What is an 'unused item pointer'
Date
Msg-id 25138.1127603950@sss.pgh.pa.us
Whole thread Raw
In response to What is an 'unused item pointer'  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: What is an 'unused item pointer'
List pgsql-general
"Jim C. Nasby" <jnasby@pervasive.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

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: What is an 'unused item pointer'
Next
From: "Jim C. Nasby"
Date:
Subject: Re: What is an 'unused item pointer'