Table size does not include toast size
От | Rafael Martinez |
---|---|
Тема | Table size does not include toast size |
Дата | |
Msg-id | 4B2F79C0.5020907@usit.uio.no обсуждение исходный текст |
Ответы |
Re: Table size does not include toast size
|
Список | pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello I wonder why the function pg_relation_size(text) does not take into account the space used by toast data in a table when returning the space used by the table. As an administrator I would expect pg_total_relation_size() to return data+toast+indexes and pg_relation_size() to return data+toast. Is this a deliberate decision? Could we change this behavior in the future? We are using a 8.3 database. Thanks in advance. regards, - --Rafael Martinez, <r.m.guerrero@usit.uio.no>Center for Information Technology ServicesUniversity of Oslo, Norway PGP Public Key: http://folk.uio.no/rafael/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.7 (GNU/Linux) iD8DBQFLL3m+BhuKQurGihQRAgBdAKCV5ZIBJyDOzGWh/En4sTvWSW67ZwCfYoYx iUYIMJCbk6li2BhYcR7JB5M= =l2YF -----END PGP SIGNATURE-----
В списке pgsql-hackers по дате отправления: