Andrey Lapin wrote:

>
> I have large database about 10Gb. If I get statistics for database, I
> have sum for all tables about 2Gb usage.
> Is it OK? May indexes use the rest of file?
> If I do backup and restore for database the size remains the same.

I don't know whether gstat counts the space take by blob pages or other
large object pages that aren't recorded on pointer pages. (I suspect it
doesn't.) That could easily be the difference. If backup/restore
doesn't change the size, then you don't have a lot of wasted space.

Regards,


Ann