Re: Table size does not include toast size

Поиск
Список
Период
Сортировка
Искать
От
Bernd Helmle
Тема
Re: Table size does not include toast size
Дата
Msg-id
4AA35169F1DE2F59726B58BA@[172.26.14.62]
Ответ на
Список
Дерево обсуждения
Table size does not include toast size Rafael Martinez <r.m.guerrero@usit.uio.no>
Re: Table size does not include toast size Tom Lane <tgl@sss.pgh.pa.us>
Re: Table size does not include toast size Rafael Martinez <r.m.guerrero@usit.uio.no>
Re: Table size does not include toast size Tom Lane <tgl@sss.pgh.pa.us>
Re: Table size does not include toast size Rafael Martinez <r.m.guerrero@usit.uio.no>
Re: Table size does not include toast size Bernd Helmle <mailings@oopsware.de>
Re: Table size does not include toast size Rafael Martinez <r.m.guerrero@usit.uio.no>
Re: Table size does not include toast size Greg Smith <greg@2ndquadrant.com>
Re: Table size does not include toast size Tom Lane <tgl@sss.pgh.pa.us>
Re: Table size does not include toast size Greg Smith <greg@2ndquadrant.com>
Re: Table size does not include toast size Greg Stark <gsstark@mit.edu>
Re: Table size does not include toast size Tom Lane <tgl@sss.pgh.pa.us>
Re: Table size does not include toast size Bernd Helmle <mailings@oopsware.de>
Re: Table size does not include toast size Bernd Helmle <mailings@oopsware.de>
Re: Table size does not include toast size Tom Lane <tgl@sss.pgh.pa.us>
Re: Table size does not include toast size Greg Smith <greg@2ndquadrant.com>
Re: Table size does not include toast size Tom Lane <tgl@sss.pgh.pa.us>
Re: Table size does not include toast size Greg Smith <greg@2ndquadrant.com>
Re: Table size does not include toast size Cédric Villemain <cedric.villemain.debian@gmail.com>
Re: Table size does not include toast size Bernd Helmle <mailings@oopsware.de>
Re: Table size does not include toast size Tom Lane <tgl@sss.pgh.pa.us>


--On 22. Dezember 2009 15:11:40 +0100 Bernd Helmle  
wrote:

>> Bernd, there's a basic spec if you have time to work on this.
>
> I see if i can get some time for it during christmas vacation (its on my
> radar for a longer period of time). I'm still working on this NOT NULL
> pg_constraint representation and would like to propose a patch fairly
> soon for this.

Since i'm not able to finish those other things in time, i wrapped up my 
existing code for this issue and came up with the attached patch, which 
should implement the behavior Tom proposed. These are two new functions 
pg_table_size() and pg_indexes_size(). This patch also changes 
pg_total_relation_size() to be a shorthand for pg_table_size() + 
pg_indexes_size().

Barring any objections i'm adding this to the CF.

-- 
Thanks

	Bernd
В списке pgsql-hackers по дате отправления
От: Fujii Masao
Дата:
От: Michael Meskes
Дата:
FAQ