Обсуждение: Variable versus constrant size tuples

Is there any performance benefit of using constant size tuples?

On 8/19/2011 4:03 AM, Krzysztof Chodak wrote:
> Is there any performance benefit of using constant size tuples?
>

If you are referring to varchar(80) vs text, then no, there is no benefit.

-Andy

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

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
>