public inbox for [email protected]  

help / color / mirror / Atom feed

How to change the default storage strategy for varlena?
2+ messages / 2 participants
[nested] [flat]

* How to change the default storage strategy for varlena?
@ 2020-07-23 20:37  Jialun Zhang <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Jialun Zhang @ 2020-07-23 20:37 UTC (permalink / raw)
  To: [email protected]

Hi All,

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?

Thanks,
Jialun Zhang


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: How to change the default storage strategy for varlena?
@ 2020-07-23 21:30  Tom Lane <[email protected]>
  parent: Jialun Zhang <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2020-07-23 21:30 UTC (permalink / raw)
  To: Jialun Zhang <[email protected]>; +Cc: [email protected]

Jialun Zhang <[email protected]> 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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2020-07-23 21:30 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-07-23 20:37 How to change the default storage strategy for varlena? Jialun Zhang <[email protected]>
2020-07-23 21:30 ` Tom Lane <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox