Re: measuring disk usage of records

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: measuring disk usage of records
Дата
Msg-id 21652.1072978697@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: measuring disk usage of records  ("Matthew Nuzum" <cobalt@bearfruit.org>)
Список pgsql-general
"Matthew Nuzum" <cobalt@bearfruit.org> writes:
> Thanks for the very quick reply... I didn't know about the dbsize stuff,
> they may help. Unfortunately, the records are mixed together.

When measuring the on-disk size of a table, don't forget to include its
indexes and its toast table (and the toast table's index).

If you are using large objects, you'll also need to think sbout charging
for the space occupied by pg_largeobject.

            regards, tom lane

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

Предыдущее
От: Tino Wildenhain
Дата:
Сообщение: Re: Is my MySQL Gaining ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: speeding up inserts