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