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 wrote:
> On Fri, Aug 19, 2011 at 4:03 AM, Krzysztof Chodak
> wrote:
>> Is there any performance benefi
On Fri, Aug 19, 2011 at 4:03 AM, Krzysztof Chodak
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
--
Sent via pg
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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your
Is there any performance benefit of using constant size tuples?
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance