Re: What's the difference between SET STORAGE MAIN and EXTENDED?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Zoltan Boszormenyi <zb(at)cybertec(dot)at>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What's the difference between SET STORAGE MAIN and EXTENDED?
Date: 2007-09-07 14:31:10
Message-ID: 21018.1189175470@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Zoltan Boszormenyi <zb(at)cybertec(dot)at> writes:
> At the end of the day, the behaviour is the same, isn't it?

No, there's a difference in terms of the priority for pushing this
column out to toast storage, versus pushing other columns of the row
out to toast. Normally we push the widest (remaining) column out,
and repeat, until the tuple is small enough. But MAIN columns stay
in, until there are no EXTENDED columns left.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Carlo Stonebanks 2007-09-07 15:01:29 Re: Query with "like" is really slow
Previous Message Ow Mun Heng 2007-09-07 14:08:34 Re: Column as arrays.. more efficient than columns?