Re: Table size does not include toast size

Поиск
Список
Период
Сортировка
От Bernd Helmle
Тема Re: Table size does not include toast size
Дата
Msg-id 570EEFCC647EC937E0883225@amenophis
обсуждение исходный текст
Ответ на 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  (Greg Smith <greg@2ndquadrant.com>)
Список pgsql-hackers

--On 21. Dezember 2009 10:01:37 -0500 Tom Lane <tgl@sss.pgh.pa.us> wrote:

> It's not supposed to.  Use pg_total_relation_size if you want a number
> that includes index and toast space.

I've created a C-Function a while ago that extracts the TOAST size for a 
given relation. This gave me the opportunity to do a pg_relation_size(oid) 
+ pg_relation_toast_size(oid) for a given table oid to calculate on disk 
data size required by a table. Maybe we should include such a function in 
core?

-- 
Thanks
Bernd


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Rafael Martinez
Дата:
Сообщение: Re: Table size does not include toast size
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Small Bug in GetConflictingVirtualXIDs