From: | Dimitri Fontaine <dfontaine(at)hi-media(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com> |
Subject: | Re: FSM rewrite committed, loose ends |
Date: | 2008-09-30 13:37:47 |
Message-ID: | 200809301537.47748.dfontaine@hi-media.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Zdenek Kotala | 2008-09-30 13:43:17 | [PATCH] PageGetTempPage cleanup |
Previous Message | Gregory Stark | 2008-09-30 13:17:15 | Re: FSM rewrite committed, loose ends |