Re: [firebird-support] Re: Data pages and data page slots

['Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]]

Thank you very much Vlad, that is what I was thinking but always is very
better to have the explanation of one expert.

Greetings.

Walter.

On Tue, Dec 13, 2016 at 11:25 AM, hv...@users.sourceforge.net
[firebird-support]  wrote:

>
>
> ---In firebird-support@yahoogroups.com, 
> wrote :
>
> > When I run GSTAT with the switch -data it shows me numbers after "data
> pages" and "data page slots".
> >
> > Usually these numbers are the same, but ... what happen when they are
> different?
>
>   Physical numbers of data pages stored at kind of array and data of this
> array are split over
> pointer pages. Every item of array also called "slot". Slot could be empty
> or contain data page
> number. When table grows, engine allocates new data pages and put its
> numbers into empty
> slots (allocating pointer pages when necessary). When data pages is freed,
> slots become empty
> but they are still present. Pointer pages freed only when table is
> dropped. Therefore number of
> "data page slots" could be much larger than number of "data pages".
>
> Hope it helps,
> Vlad
>
> 
>

[firebird-support] Re: Data pages and data page slots

[hv...@users.sourceforge.net [firebird-support]]

---In firebird-support@yahoogroups.com,  wrote :
 
 > When I run GSTAT with the switch -data it shows me numbers after "data 
 > pages" and "data page slots". >

 > Usually these numbers are the same, but ... what happen when they are 
 > different?

  Physical numbers of data pages stored at kind of array and data of this array 
are split over
pointer pages. Every item of array also called "slot". Slot could be empty or 
contain data page 
number. When table grows, engine allocates new data pages and put its numbers 
into empty 
slots (allocating pointer pages when necessary). When data pages is freed, 
slots become empty 
but they are still present. Pointer pages freed only when table is dropped. 
Therefore number of 
"data page slots" could be much larger than number of "data pages". 

Hope it helps,
Vlad