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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: What's the difference between SET STORAGE MAIN and EXTENDED?
Дата
Msg-id 21018.1189175470@sss.pgh.pa.us
обсуждение исходный текст
Ответ на What's the difference between SET STORAGE MAIN and EXTENDED?  (Zoltan Boszormenyi <zb@cybertec.at>)
Ответы Re: What's the difference between SET STORAGE MAIN and EXTENDED?  (Zoltan Boszormenyi <zb@cybertec.at>)
Список 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 по дате отправления:

Предыдущее
От: "Ow Mun Heng"
Дата:
Сообщение: Re: Column as arrays.. more efficient than columns?
Следующее
От: "Carlo Stonebanks"
Дата:
Сообщение: Re: Query with "like" is really slow