Subject RE: [firebird-support] Re: How to find out what is making a database so large
Author Maya Opperman
--- In firebird-support@yahoogroups.com, Karol Bieniaszewski> wrote:
>> I have a 10 GB database I would like to try reduce in size. Quite a few of the tables have blobs for images and text memos.
>> What would be the easiest way of isolating which table, and which rows within that table, are taking up the most space?

>use gstat for this
>you get info how many pages are used by table
>pagesize*page_count = size of table
>size of table * avg fill = size of real data in table
>the rest is free space

Thanks, Karol! That worked great, and IBExpert put the results in a nice easy to read table format for me ;-)