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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jialun Zhang <reatank(at)gmail(dot)com>
Cc: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: How to change the default storage strategy for varlena?
Date: 2020-07-23 21:30:14
Message-ID: 299365.1595539814@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Jialun Zhang <reatank(at)gmail(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message bx 2020-07-24 19:39:26 deviation of 12 from 10 or 11
Previous Message Jialun Zhang 2020-07-23 20:37:48 How to change the default storage strategy for varlena?