[firebird-support] Data pages and data page slots

 

Hello everybody

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?

I understood that the difference between them means the count of pages without any relevant data. Pages allocated some time and not more useful for that table at this moment because they just have garbage.

However, if I want to delete those pages, it is not possible, neither with GFIX -sweep neither with a SELECT COUNT(*) FROM MyTable

In both cases GSTAT -data continues showing the same numbers.

For example, I have a table whose "data pages" is 72 and their "data page slots" is 975, 

Is there something wrong there? Is possible (and useful) make these numbers equals? which is the meaning of those numbers?

Someone can explain me that or tell me where I can find information? Mr Google was not polite with me.

Of course, I know a cycle backup/restore put both numbers equals, but ... is that the only way? or I can make "data pages" equal to "data page slots" without a cycle backup/restore?

Greetings.

Walter.

__._,_.___

---

Posted by: "Walter R. Ojeda Valiente" <sistemas2000profesional@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 5

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___