Re: FSM rewrite committed, loose ends

Le mardi 30 septembre 2008, Heikki Linnakangas a écrit :
> > You forgot the toast size.
>
> Yeah, pg_total_relation_size() - pg_relation_size() is not equal to the
> total size of indexes because of that.

Oops. Thanks for pointing this to me...

> But you can do SUM(pg_relation_size(index)) across all the indexes for
> that:

For convenience, would it be possible to see about having all this provided by
PostgreSQL?
a. pg_relation_size()
b. pg_relation_toast_size()
c. pg_relation_fsm_size()
d. pg_relation_indexes_size()
e. pg_total_relation_size() = a + b + c + d

Are there some other things to add in the mix?

Maybe I'm the only one with the need for some simple functions covering all
the base, but I thought I'd ask nevertheless :)

Regards,
--
dim