| Subject | Re: How to find out what is making a database so large |
|---|---|
| Author | karolbieniaszewski |
| Post date | 2011-04-04T08:08:27Z |
--- In firebird-support@yahoogroups.com, Maya Opperman <maya@...> wrote:
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
you can also can do backap
gback -USE_ALL_SPACE - to see how big is database containing only data without free space allocation
Karol Bieniaszewski
>use gstat for this
> Hi,
>
> 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?
>
> Thanks
> Maya
>
>
> [Non-text portions of this message have been removed]
>
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
you can also can do backap
gback -USE_ALL_SPACE - to see how big is database containing only data without free space allocation
Karol Bieniaszewski