Re: What's the difference between SET STORAGE MAIN and EXTENDED? - Mailing list pgsql-general

From Tom Lane
Subject Re: What's the difference between SET STORAGE MAIN and EXTENDED?
Date
Msg-id 21018.1189175470@sss.pgh.pa.us
Whole thread Raw
In response to What's the difference between SET STORAGE MAIN and EXTENDED?  (Zoltan Boszormenyi <zb@cybertec.at>)
Responses Re: What's the difference between SET STORAGE MAIN and EXTENDED?  (Zoltan Boszormenyi <zb@cybertec.at>)
List pgsql-general
Zoltan Boszormenyi <zb@cybertec.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

pgsql-general by date:

Previous
From: "Ow Mun Heng"
Date:
Subject: Re: Column as arrays.. more efficient than columns?
Next
From: "Carlo Stonebanks"
Date:
Subject: Re: Query with "like" is really slow