| Subject | How to determine size of database structures? |
|---|---|
| Author | |
| Post date | 2015-05-14T13:57:42Z |
Hi guys.
I know that I need to use gstat, and I know that I have detailed description about it here: Gstat Examples And Interpretation
However, the description does not say how to determine how much space on hard drive is taken by tables and indices. Somewhere I've read that to calculate size of a table I need to multiply the DB page size with data pages reported by gstat for each table. Is that a correct method?
Could you tell me how to calculate how much space is taken by indicies based on gstat output file?
Regards.
I know that I need to use gstat, and I know that I have detailed description about it here: Gstat Examples And Interpretation
However, the description does not say how to determine how much space on hard drive is taken by tables and indices. Somewhere I've read that to calculate size of a table I need to multiply the DB page size with data pages reported by gstat for each table. Is that a correct method?
Could you tell me how to calculate how much space is taken by indicies based on gstat output file?
Regards.