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 1lfNbC-0002TE-H4 for pgsql-hackers@arkaria.postgresql.org; Sat, 08 May 2021 14:06:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lfNbB-0008NQ-24 for pgsql-hackers@arkaria.postgresql.org; Sat, 08 May 2021 14:06:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lfNbA-0008NH-QL for pgsql-hackers@lists.postgresql.org; Sat, 08 May 2021 14:06:28 +0000 Received: from mail-oi1-x231.google.com ([2607:f8b0:4864:20::231]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lfNb4-0000wn-4S for pgsql-hackers@lists.postgresql.org; Sat, 08 May 2021 14:06:28 +0000 Received: by mail-oi1-x231.google.com with SMTP id b25so6258532oic.0 for ; Sat, 08 May 2021 07:06:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=jHn3V9wARI8v7rxDAWgVmD3UpcW6MTA5dtgzowB62/8=; b=dbGAxwGrNrSBQSR+hD4JLpwWhesZ1/3bmQs6eHTQmXKCYvdZxU5sc3IGNGaCRqEA0E VWv4DPRCV6H/Ltt4VLAMbvcDQW/3enG+AUdKZ3j+oNEHbjHeVTG253XSHQTH+1LV0COs e4TNXzyEo2WhtR7xcOOgjp4vkJQXfxmNA4trKmKRKjOvfT7NKZYb7GS8bUUwvjvyvYZ6 rBUiAR1oP+9hvEB4EhxNpQNsjEK9T0wl9nann2kBtmgrRDzsRMSBQlEJ8ftzkFIv/678 Y+wiH0yJCjhDKK6W1ZxdHiNvZZyLrmMY0lzl9Jyt17yylGVYlFDKrde72p+XjkfgdD7H NOdA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=jHn3V9wARI8v7rxDAWgVmD3UpcW6MTA5dtgzowB62/8=; b=Gy+zeRQXppt94KyGtzRP3If65ciMKxV/a/act+AkJN8Sk273dI+bk0HuozibTvZGpj rAAxBNOMGi8rzf7Wpab6hl36nuLFlUhWZqXoGEVkch5p9ftDBf+S0SFegSAvOUamENoc 7ZV5NU+ZGTIt6Vk/o/2dNUqQxGwLrX2MdH4YQC4ub0mi/TdY+cKMfq88U/ovF/yBVbfk bqrgcoomVHbH3JfDnlmtK++qZnXLUOlfRPeYmFtNGHoDEdGjUxZRty29Y1pZx/E3qzwa TAi6d/kzce3TFe3Bz6bYU/JHykOuBqfiYzquQGoomuvJn8Ijuv3XTpvYkeLGSw/ekfID T82g== X-Gm-Message-State: AOAM532iIBO0kI5m9LDqyaI0hDVfFziGsgUXHVuZJ9y1mBWB21F/jnCJ qcg3xV2jU7S86Y5E2ZnQQjGG1w== X-Google-Smtp-Source: ABdhPJzphjJaPOKSmq9+erEHpDPaAmugBg0wfIUko5+tAvrLSHME6s4hL4XZa6oJLi6xkDhlpJU3Wg== X-Received: by 2002:aca:5856:: with SMTP id m83mr18590781oib.20.1620482780185; Sat, 08 May 2021 07:06:20 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id x18sm1553713oix.28.2021.05.08.07.06.19 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sat, 08 May 2021 07:06:19 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 43FEA80076C; Sat, 8 May 2021 09:06:18 -0500 (CDT) Date: Sat, 8 May 2021 09:06:18 -0500 From: Justin Pryzby To: Michael Paquier Cc: Dilip Kumar , Robert Haas , Postgres hackers , Jacob Champion Subject: Re: Small issues with CREATE TABLE COMPRESSION Message-ID: <20210508140618.GA10189@telsasoft.com> References: <20210508132239.GX27406@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20210508132239.GX27406@telsasoft.com> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk | You need LZ4, if you want to support the compression of data with this method; see CREATE TABLE. I suggest that should reference guc-default-toast-compression instead of CREATE TABLE, since CREATE TABLE is large and very non-specific. Also, in at least 3 places there's extraneous trailing whitespace. Two of these should (I think) be a blank line. + .$ + $ + $ + $ $ + compression of table data. $ + $ + $ + $ + $