Re: Variable versus constrant size tuples

Поиск
Список
Период
Сортировка
От Krzysztof Chodak
Тема Re: Variable versus constrant size tuples
Дата
Msg-id CAMiSJ3pgqPE851Ra3Ri3R6vkD8BODamQJ3R9tNWjnkA6oT0EJA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Variable versus constrant size tuples  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-performance
Thank you. Now I see that page consists of record pointers list build
from offset and length so there is no benefit of having constant
length here.

On Fri, Aug 19, 2011 at 17:03, Merlin Moncure <mmoncure@gmail.com> wrote:
> On Fri, Aug 19, 2011 at 4:03 AM, Krzysztof Chodak
> <krzysztof.chodak@gmail.com> wrote:
>> Is there any performance benefit of using constant size tuples?
>
> not really.  If your tuple size is under a known maximum length, then
> a toast table doesn't have to be created.  that's a pretty minor
> detail though.
>
> merlin
>

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: settings input for upgrade
Следующее
От: hyelluas
Дата:
Сообщение: Re: tunning strategy needed