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
signature.asc
Description: This is a digitally signed message part.