Postgres Pro
Downloads
Home   >   mailing lists

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

From Teodor Sigaev
Subject Re: CREATE TABLE ( .. STORAGE ..)
Date
Msg-id ea723b92-d87a-aeef-3467-56453a36921d@sigaev.ru
Whole thread Raw
In response to Re: CREATE TABLE ( .. STORAGE ..)  (wenjing zeng <wjzeng2012@gmail.com>)
Responses Re: CREATE TABLE ( .. STORAGE ..)  (Matthias van de Meent <boekewurm+postgres@gmail.com>)
List pgsql-hackers
Tree view 
Hi!

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

Thank you, fixed, that was just an oversight.

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

Thank you, fixed

> 
> 
> 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>
> 

-- 
Teodor Sigaev                      E-mail: teodor@sigaev.ru
                                       WWW: http://www.sigaev.ru/
Attachment

pgsql-hackers by date:

Previous
From: Ajin Cherian
Date:
Subject: Re: row filtering for logical replication
Next
From: Bharath Rupireddy
Date:
Subject: Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work