Subject | Re: Data pages and data page slots |
---|---|
Author | |
Post date | 2016-12-13T15:25:33Z |
---In firebird-support@yahoogroups.com, <sistemas2000profesional@...> wrote :
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
Physical numbers of data pages stored at kind of array and data of this array are split over> 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?
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