Re: Variable versus constrant size tuples - Mailing list pgsql-performance

From Krzysztof Chodak
Subject Re: Variable versus constrant size tuples
Date
Msg-id CAMiSJ3pgqPE851Ra3Ri3R6vkD8BODamQJ3R9tNWjnkA6oT0EJA@mail.gmail.com
Whole thread Raw
In response to Re: Variable versus constrant size tuples  (Merlin Moncure <mmoncure@gmail.com>)
List 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 by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: settings input for upgrade
Next
From: hyelluas
Date:
Subject: Re: tunning strategy needed