Postgres Pro
Downloads
Home   >   mailing lists

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

From wenjing zeng
Subject Re: CREATE TABLE ( .. STORAGE ..)
Date
Msg-id ECF2E7F0-D237-44EA-971B-CB163B4EB457@gmail.com
Whole thread Raw
In response to CREATE TABLE ( .. STORAGE ..)  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: CREATE TABLE ( .. STORAGE ..)
List pgsql-hackers
Tree view 
HI

For patch create_table_storage-v1

1
+ALTER opt_column ColId SET STORAGE name

+opt_column_storage:
+            STORAGE    ColId                            { $$ = $2; }

Are they both set to name or ColId? Although they are the same.

2 For ColumnDef new member storage_name, did you miss the function _copyColumnDef()  _equalColumnDef()?


Regards
Wenjing


> 2021年12月27日 15:51，Teodor Sigaev <teodor@sigaev.ru> 写道：
>
> Hi!
>
> Working on pluggable toaster (mostly, for JSONB improvements, see links below) I had found that STORAGE attribute on
columnis impossible to set  in CREATE TABLE command but COMPRESS option is possible. It looks unreasonable. Suggested
patchimplements 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/<create_table_storage-v1.patch.gz>

pgsql-hackers by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: MultiXact\SLRU buffers configuration
Next
From: "osumi.takamichi@fujitsu.com"
Date:
Subject: RE: Skipping logical replication transactions on subscriber side