Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n1knP-0001LS-70 for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Dec 2021 07:51:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n1knO-0002r3-2V for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Dec 2021 07:51:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n1knN-0002qu-Pl for pgsql-hackers@lists.postgresql.org; Mon, 27 Dec 2021 07:51:49 +0000 Received: from hook.sigaev.ru ([93.180.27.50]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n1knK-0000yt-KJ for pgsql-hackers@postgreSQL.org; Mon, 27 Dec 2021 07:51:48 +0000 Received: from [192.168.1.8] (128-72-215-18.broadband.corbina.ru [128.72.215.18]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: teodor) by hook.sigaev.ru (Postfix) with ESMTPSA id D9D53B191F0 for ; Mon, 27 Dec 2021 10:51:42 +0300 (MSK) Content-Type: multipart/mixed; boundary="------------yo668YaEhzhr9a5N8sGVDdsp" Message-ID: Date: Mon, 27 Dec 2021 10:51:42 +0300 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:91.0) Gecko/20100101 Thunderbird/91.4.0 Content-Language: en-US To: pgsql-hackers From: Teodor Sigaev Subject: CREATE TABLE ( .. STORAGE ..) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------yo668YaEhzhr9a5N8sGVDdsp Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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/ --------------yo668YaEhzhr9a5N8sGVDdsp Content-Type: application/gzip; name="create_table_storage-v1.patch.gz" Content-Disposition: attachment; filename="create_table_storage-v1.patch.gz" Content-Transfer-Encoding: base64 H4sIAIBwyWEAA+1abXPiRhL+DL+iz7W5gHnHgI3t5UJssqGCjWNwLqm9FDVIg9FZSEQStqn1 /vfr7hkhCbCN97Zylarz1iJp1NPT0/30y8zItCYTKBRurQBEyXSNku/h/9uZXfLkpGR4UgRy FIixLYvUCuMdiNKWY8pHGDcPx+OmKc1KvVg0yrWJqB6Oy6YBlXK5UaulC4XCTmOmc7ncbuN+ 9x0UqtX8IeT4Fx+vXD+49eTg5x5g/8VMOoEILNdJA5wiD3/puHPf8k3rvpWG0/AR78+uO+1h Bz7ivw+9/vftHjxBr3+G19/hEww7F1f96/b1b9hK9/AZb24ue/0PHzrnSDFsf9+jzt0f4LI/ hM6v3cFwgO045twWhiSRwbCF77/fmwtPzGQgvb0WT2Xk4ONpKUbZggx8TBcAB36FgeHai5mz jcMrHU0RiFGwnK93+whn/Yur685g0O1fJpjgWLO5J30ftTlCLlPXXOv7O/fu9UiPaz1tm62w pcNuEzRcxw88YTnBhrzFYhEZ/Z7O/W/UNRgiLj50cOyrXrt7ibDo/DrsXF8ygOj28hwR8gQX 9PKz1tFfU8NAf0/JgRWCn+scdul1f1oT2HcXnqF9eWPABKVt3cmRO98yOSXXZzXIx7x6VjGh Wc03MCjgpXpEYeGf3eGP6FQX/fOb3s3gNZU4GDc8yxjZFj4KOzlsHq47F2rM05Jt+QESzdRM T0v3wqMmjDreEtsIlHCabMwxJTKeIer0CK1BZ/hGJNHYqu9piZlpxpFEOSUjzSt8gOHU8mHi ejPwZeBDMJXgB64nbiXMXFPSKxCgIFFU1GjbwHNtHx6mCEnpYSfLD/kpSkCyqbRNsBzbciQg E8tBPr7EzqbwlnAqDM91lrPWsN8eDE9L4SMwAPIgHDNkGQ0jgdwubPen7gKHGKPBtJtIk0Zy 3KAYKZJVF+kGZgs/oD4LpA450SQn1qM0C7Z0boMp3At7IX3wF8YUhI/GQUdvIZjlrfRQu/RE EkI0bzXRPCycSJiYFBdJIZTOw06R7rS3EwhppjEGoeU3mchHfHaEvWITF4HZsDaTrAg5O7Ba Y1SE17iwjeRELOyAOc4w+4bMiAOQ7ohMBKjd+dz1ArSXU3jWXBqMxZDJjY9omryolwfLtmEm 7hDJizFGIcu5BXeO7yhi+ICpX/O6lwhEW3iIdWXhABUQN69qHS8DKcJmjQxv4cBEoAt7K13h jGj2c4kKDJYkpOVQgULKC13Kn2PQKELYZSBx5EesQgBxcCcd8/2epiwELnLfK7W0Fj2J3MhN eRKhNk5LMV+Ox57cltiTUxFpLSBFsWel0uey0dZU8XJ+2oxJsBaTzHj1ScXdWBikiRKynqEN /BIHBGNm+kUDa8DXSHTlWavLelMemHWjUSxWzKOjZqVZPqxXk5Xnq8xU3fkqGWWYRvmQMgxd uO70qcw04N61TEALY7g5X8xll6RrB4EwpplrqTI0oELRHF3zETNJrI1b0iGjHqoM9j/I4Iqp pfkDgsK6dX6Sy2ssYxPcULd4lz1JJ6RoD88lDXw2lcbdpfuW/sZUeIBjo+SeNV4E8iwyfKaP vEUQoH9YZl6R7seAgWxyMTapOJuBQnuGywXdVXsAZR+SgP6V9hEi/90f26hZrpONmuVGvlol I53LCQbgcOqZM15PDIJZQGLMAj0bT9p3CKs80EzdB0d6XRMNk0pZE0DRbeRSiLtClt6lUCVe oYW/sTfw/lktrsiVHplF7E+l1o2RULfpXFIQrT+uabP08hP9ROKEsSgpSmSJLVxOmENpny+w D76YSAxxBgHpGJdVlHJB2Lb7ABy3YhGPzOhjSrJR4LA4oERA0TRkh3mDq4CCeEBsF3Vzia80 s79lNoV/D8PfrnSBNNLl0RP3QFUNkXnXH5Io5KVrus1ms4pQYqjCBJTpXF/3r/OqLZXKSM8z UGpqPuufd0Y/4Drw5rozwnXcaHBzhcu+Yec8u6IHpJ/5t5m92Ow4zcE3OGPhYMKxlzAV91Fl xfLurTikUiqy83piNN4ir7LAZ4rh+IseQcbgqHNYr9Bqt3HYOMpXDwjTuBR4lEbbNM9YnowK HPsPfyzkAguUto2BWJpDUkwXUwrso45igQfBTuATITCKSgy0IyJG3Zysvx8vMS3Sa5pHoYVU 3LJBJ2wMOAk6bjlJF5J0EUQjSt1GingJ7Qz2Z5i9De8K7l8X7dvBrrEeQX1T9ufhvh3tcdNF iN8K+Dfi/SvAfQvaN+RlGyDgU9L25Qs23QaQddjtFoBJnP5m5H028K4NgqBwFjZ5QUhu+SNs HFHrCTvrUbVaJmc9qtYPMA9h00AGXBFoNF55VKcGloylY/LHyDtpSH0flQb98b+lEaDHk3Bp HQCQdYjxJK94rkVRLxHwebiktd6+Ix9+ofo2TxtdP+HauAO2a9xxKk7DJ3RTzuCokniWJlVw ewr7r6wAqXDYVExoav9RivlwMbdlKqDflW6a+WqNlNOo5I+iQPb15oFDJzQFQl25yEi1cZWD rtH125mo+4BXDwTGQio2YzQyriuQZkXKlUqBXXh+O8KXBtb9xmyeifXKwx5WxpazlyV/LmeR PqYx2HRxGpXgD6+xDddtu3AOF0xvYo4YNXdlTovCnZnPdtTHRUwdeCEorkezwtZg1r38pd3r no+u2tftiw5OfYTPN52spl9FM8vBhGVFkZwj2r/2vvH/tbenaVNxCGQVKJICl0+4TII7Kee8 drZs6cEfC0sGFOMLHNASPbalpHVoqSo47kUU93ibDcOFk1kxCP0Dq1O4dh86j4a98K172UMf ZibkaJWjZv0wfwA5vDk8IJfD1i8t7VkwTwYLzwFDLQBxHKpT4iV/OveWmj+d+6Rz/O6ehPlB S7HpQ7kv9KGtPCPveQPbhPc8y1b5zY5sZ6/O/iI2+bAu2pb/3+AxuTd4TG67x0SivuIrnPw/ P789gKtUjNelW0/Misu1NXrind4QODBrplk7kLXDcbFYkweGMW5U5VHz+Q2BJJfNnYDke3Kt +hGfPKlLtAWgchJtSF1LY+GRR/5iyYeBtDEXZZQDoGc7nMBUtY6KRbP7YT7D0t1bqjDwDav5 1MH2VoqL+LPVVjvwc8+6k2e2WKDZQ2oLLaWp6W2f9855pLW2dEH3QI6tVGp1EhDVT+48GG02 p3Nf1i/erKGyEpr2iFopXMT8vBA2Cbs2eXwTm3riqWPLGUSPFHrWdHEnlyOsQY2pOh04qBzy maG6YpOgVdJIn2XMzGNdFL57h6E3o4yS5WImRcsyUFBu99Bb9MnfKZmzpZs+nvV7NxeXv8Mp zlW9iO/vn8a8pKUSRSr1pPtGGqI5ds1ET25hX9uJnIZWMn/SE+LVoILRzMTCCadHQKUZZhLv snqyKQfXSosx6/I9lmijqD5ThdxBrXmQr1Qhp254SUorFLXiJMtIJ1D6fII1APMAn4C1/K5y AqxZrqzUlLCsPk6paRFLms5zwNJHw7fS4YMbdVzkQxxOuZ2YhuHty8dJKPwsHHNN2av2uKI1 WpQ2omZS/qVur57o4sRJrE/o1cGJjsJOcnm7/m6tWy02kuVMDXeB7kW1TazZH2E9rZb83kIm 34RrHnw5EZh8NCzq5UMs63N4PVLl/dc2aSSEJx5G4SHEe7i86fUSOnXvpPnSe9umsuc9dFWC w4eYjifmQziw0pV6M5jbVhAzeuZdPQ9/Z3YhuP2wwbZVeM5HJkhyrYfG2eTa2IFrtH6F5dLH JTnqK44qMp2uIr9bwWo9simbNWidijZr1PKVChltu2lCdy7tdy6uhr/tl0IBtC+ziiNvzm26 1zHPWMcphYckCwQ61ZU7DZOjYXLpuBMqCWMNyYQRY2KLOcLQzLyr5HHQrBb7pVG7POhGpWI5 WH6bskTZylfVAt8Wp7qQeJ4gPMQw6uJIHDTHk0qxWDdwhTyRk/phZbNmeYFVVLi8QKS3EvkA Ay+cAinKoJfQSndhsL6Uu6I6xq5rp1Lx/Q1Kf/SdC5kAInSCP5eGNbGk+Q/Ka7GeE8+d8Q4Q dw33kmg7ns8ewKBAQERqpaOqS2ahthrCfQZOvLEdIV8GAS7Z83QQXObDs9DTuahUnffj4fBk OwdQochTU4oxYiHIUXgfJBZrmFE4Gp8TQgZjpyccnzappAmscwyZUmYhySYZlU5gk1Ocj3yc e3E2alaWiZnVCpYrnYQNqykh8QZMA+kHJU/ekiuXkDHWpNIsxeqforsINIJ2otXgrdbMinFo mNWjcrE4qdXrZXk4Rihvgnc3rhGOd6NXX4IdVNS3YHwN6zoNKY+q8QrtAoX4m1QBQYshahsZ N0WEDEh+h5EJ5zIRlu2ngZdWx+rk3PWtQMYIK7Q/SpvHY4mJHyOtgJmcjZEtHRYHvrTRuZBV vGSbiSU4Em0euCypULvHSjasizgnhj6CilnVKxkBdJxNa65XiXBpz9fVWo5X19k1RSR6qhf0 Rcdarxc74QTGpOIVuMusO08+eFYkoYsNM/dekk4S032bOOHSWw9RoNHj3BRCapzi+NokhDxM cZUMLlcA38bH+Pb4GEHHZ+A4R8C6LlMBz32gTZBcocDHAyuzGa6HJg8c2pB9Xv8jAg3admUG pZz1CZANI1yt7brrr1Je2npnUNG46ruLOLzmnjsXtyidT2pXnqtlt5dpXXLp9oTklvmIw62h aZwHsQNq9Bw2rUX7LyfaLvWKsku9tum5b+cJOn/Bkzov4Y/QzsJv5PD+ErMY836iQ2HG5hPo hQ3wraDPo+hjkYBpfMOzuGSD9OpwOlfYvEvcbyWI0248ouQC9Edz7KJ8F/09bbt9Ws08Qctv 0jl09rczZN9ep1UMAWGr70MwPsuwvBNDPhOR/rH6WmRvHXh7MKbkp/H2Skrz/7ATuQGft+WR LWQ6kdUnwqjWj+pmExNZo2GWzUm9WW9sqcJeZfhMDttGylu19UqD0pe+/hnp6//558/NP5V6 latuvnL+8XlbkI64+HAZr5iKTlvoOcLH2O6PuHmkBeIKeX474rSU3jV5/Qn56i+Wc/4DQUWZ EgUxAAA= --------------yo668YaEhzhr9a5N8sGVDdsp--