Subject | Re: [firebird-support] size of tables (bytes) - not via rdb$pages? |
---|---|
Author | Vlad Khorsun |
Post date | 2008-09-04T16:30:18Z |
> It looks like rdb$pages only contains "important" pages needed by the engine, not a full catalogueLook at gstat output.
> of all pages currently allocated. I was looking for a way to get an idea of how many pages each
> table was using (data, index, and optionally blob?) to get an estimate of how space was being used
> within a database (page size * number of pages, realizing lots of pages won't be completely full,
> but also knowing that they still use space on disk even if not fully utilized). Since we can't
> break out each table into an individual file, we can't just use the filesystem for that. Is there
> some other way of doing this? Something other than taking the number of rows in the table * some
> estimate of the row size? (I know Ann has written guides for estimating this, as part of her ODS
> documentation, but I'm looking for "real size", not "maximum size".) I'm guessing there are some
> tools that do this (some of the recovery tools, perhaps?) but can they be applied to a running
> database?
Regards,
Vlad