Subject Re: [firebird-support] Table size on disk - how to find?
Author Stefan Heymann
Pepak,

the *only* way to make a Firebird database file smaller is a backup &
restore. Without that, the database file will always grow, never
shrink. However, unused database pages will get reused by the server.

Best Regards

Stefan




> Hi!

> I would like to reduce the size of my Firebird 1.5 database. In order to do
> that I need to know on which tables I should focus. Is there some way to
> find out how much space is a table and its associated metadata (such as
> indexes) taking up? I thought I could get at least the data size (not index
> size) by reading a number of pages from RDB$PAGES and multiplying it with
> page size, but the results seem to be way off ("SELECT count(*) FROM
> rdb$pages" only lists about 600 pages for a 700+ MB database with page size
> of 4 KB). Is there some better way? I only need to do this once or twice, so
> a standalone application that would list this information for me would be
> just fine, although I would prefer to be able to read this information from
> the database from my application.

> Thanks,

> Pepak






> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !

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

> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links



>



--
Stefan Heymann
www.destructor.de/firebird