Re: 7.1 Beta 1 & table size calculation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7.1 Beta 1 & table size calculation
Дата
Msg-id 16576.977414592@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 7.1 Beta 1 & table size calculation  ("Dale Anderson" <danderso@crystalsugar.com>)
Список pgsql-general
"Dale Anderson" <danderso@crystalsugar.com> writes:
> Is the relpages counts under 7.1 no longer valid of the physical page
> storage?

It's still valid, but you need to include the associated TOAST table
as well as the primary relation.

Keep in mind also that TOAST can do inline compression.  If you made
your test record with something like repeat('x',29000), it probably
got compressed to not very many bytes ...

            regards, tom lane

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

Предыдущее
От: Mike Castle
Дата:
Сообщение: Re: red hat/mysql fiasco
Следующее
От: "Mike Sears"
Дата:
Сообщение: Re: red hat/mysql fiasco