Postgres Pro
Downloads
Home   >   mailing lists

CREATE TABLE ( .. STORAGE ..) - Mailing list pgsql-hackers

From Teodor Sigaev
Subject CREATE TABLE ( .. STORAGE ..)
Date
Msg-id de83407a-ae3d-a8e1-a788-920eb334f25b@sigaev.ru
Whole thread Raw
Responses Re: CREATE TABLE ( .. STORAGE ..)  (wenjing zeng <wjzeng2012@gmail.com>)
List pgsql-hackers
Tree view 
Hi!

Working on pluggable toaster (mostly, for JSONB improvements, see links 
below) I had found that STORAGE attribute on column is impossible to set 
  in CREATE TABLE command but COMPRESS option is possible. It looks 
unreasonable. Suggested patch implements this possibility.

[1] http://www.sai.msu.su/~megera/postgres/talks/jsonb-pgconfnyc-2021.pdf
[2] http://www.sai.msu.su/~megera/postgres/talks/jsonb-pgvision-2021.pdf
[3] http://www.sai.msu.su/~megera/postgres/talks/jsonb-pgconfonline-2021.pdf
[4] http://www.sai.msu.su/~megera/postgres/talks/bytea-pgconfonline-2021.pdf

PS I will propose pluggable toaster patch a bit later
-- 
Teodor Sigaev                      E-mail: teodor@sigaev.ru
                                       WWW: http://www.sigaev.ru/
Attachment

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Fwd: Schema variables - new implementation for Postgres 15
Next
From: "Joel Jacobson"
Date:
Subject: Re: Foreign key joins revisited