Re: How to change the default storage strategy for varlena?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to change the default storage strategy for varlena?
Дата
Msg-id 299365.1595539814@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How to change the default storage strategy for varlena?  (Jialun Zhang <reatank@gmail.com>)
Список pgsql-novice
Jialun Zhang <reatank@gmail.com> writes:
> The defualt stroage strategy for varlena is 'x', i.e. EXTENDED. Is there a
> way to change it, from either front end or source code?

As of v13 you could do something like

alter type varchar set (storage = main);

(repeat for every varlena type in the system, if that is indeed your
desire).  This seems like a remarkably bad idea, but it's breaking
nobody's database but your own.

            regards, tom lane



В списке pgsql-novice по дате отправления:

Предыдущее
От: Jialun Zhang
Дата:
Сообщение: How to change the default storage strategy for varlena?
Следующее
От: bx
Дата:
Сообщение: deviation of 12 from 10 or 11