Hi,
I am trying to figure out the amount of free space within my database, so that I can detect when I'm nearing exhausting the disk space. I'm using firebird-v2.5.2.
I know that (total_pages * page_size) = size on disk. This doesn't tell me how many of those allocated pages are free. If I delete a large number of records, the file size remains the same but pages should be freed internally. It is this free space I need to measure. While gstat gives me the number of data pages for each table, this *doesn't* include BLOB pages (which are the bulk of my data). How can I count BLOB pages?
Thanks,
BC
__._,_.___
Posted by: Bryan Cole <bryan.cole@teraview.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 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/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment