Re: [GENERAL] What is an 'unused item pointer'

2005-09-26 Thread Jim C. Nasby
On Sun, Sep 25, 2005 at 12:09:24AM -0400, Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > On Sat, Sep 24, 2005 at 07:19:10PM -0400, Tom Lane wrote: > >> Currently, when a tuple is reclaimed by VACUUM, we just mark its item > >> pointer as unused (and hence recyclable). I think it

Re: [GENERAL] What is an 'unused item pointer'

2005-09-24 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > On Sat, Sep 24, 2005 at 07:19:10PM -0400, Tom Lane wrote: >> 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

Re: [GENERAL] What is an 'unused item pointer'

2005-09-24 Thread Jim C. Nasby
On Sat, Sep 24, 2005 at 07:19:10PM -0400, Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> 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

Re: [GENERAL] What is an 'unused item pointer'

2005-09-24 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> 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 t