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 1kQo0V-0002zK-Ez for pgsql-hackers@arkaria.postgresql.org; Fri, 09 Oct 2020 08:44:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kQo0U-0002OJ-96 for pgsql-hackers@arkaria.postgresql.org; Fri, 09 Oct 2020 08:44:06 +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 1kQo0U-0002OC-2L for pgsql-hackers@lists.postgresql.org; Fri, 09 Oct 2020 08:44:06 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kQo0N-0005kv-3p for pgsql-hackers@postgresql.org; Fri, 09 Oct 2020 08:44:05 +0000 Received: from oss.nttdata.com (localhost [127.0.0.1]) by oss.nttdata.com (Postfix) with ESMTP id BDF8160342 for ; Fri, 9 Oct 2020 17:43:55 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.102.3 at oss.nttdata.com MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=_758c37f9850d8e6c2dfb5e4118a6a83b" Date: Fri, 09 Oct 2020 17:43:55 +0900 From: Shinya Okano To: pgsql-hackers Subject: Add a description to the documentation that toast_tuple_target affects "Main" Message-ID: <93f46e311a67422e89e770d236059817@oss.nttdata.com> X-Sender: btokanosn@oss.nttdata.com User-Agent: Roundcube Webmail/1.1.9 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --=_758c37f9850d8e6c2dfb5e4118a6a83b Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed Hi, Regarding the toast_tuple_target parameter of CREATE TABLE, the documentation says that it only affects External or Extended, but it actually affects the compression of Main as well. The attached patch modifies the document to match the actual behavior. Regards, -- Shinya Okano --=_758c37f9850d8e6c2dfb5e4118a6a83b Content-Transfer-Encoding: base64 Content-Type: text/x-diff; charset=us-ascii; name=Add-Main-to-the-toast_tuple_target-doc.patch Content-Disposition: attachment; filename=Add-Main-to-the-toast_tuple_target-doc.patch; size=1310 ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RhYmxlLnNnbWwgYi9kb2Mvc3Jj L3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21sCmluZGV4IDI4Zjg0NDA3MWIuLjc2ZDgwZmI1Njcg MTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RhYmxlLnNnbWwKKysrIGIvZG9j L3NyYy9zZ21sL3JlZi9jcmVhdGVfdGFibGUuc2dtbApAQCAtMTM1OSwxMCArMTM1OSwxMSBAQCBX SVRIICggTU9EVUxVUyA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+bnVtZXJpY19saXRl cmFsPC9yZXBsYWNlYWJsZT4sIFJFTQogICAgIDxsaXN0aXRlbT4KICAgICAgPHBhcmE+CiAgICAg ICBUaGUgdG9hc3RfdHVwbGVfdGFyZ2V0IHNwZWNpZmllcyB0aGUgbWluaW11bSB0dXBsZSBsZW5n dGggcmVxdWlyZWQgYmVmb3JlCi0gICAgICB3ZSB0cnkgdG8gbW92ZSBsb25nIGNvbHVtbiB2YWx1 ZXMgaW50byBUT0FTVCB0YWJsZXMsIGFuZCBpcyBhbHNvIHRoZQotICAgICAgdGFyZ2V0IGxlbmd0 aCB3ZSB0cnkgdG8gcmVkdWNlIHRoZSBsZW5ndGggYmVsb3cgb25jZSB0b2FzdGluZyBiZWdpbnMu Ci0gICAgICBUaGlzIG9ubHkgYWZmZWN0cyBjb2x1bW5zIG1hcmtlZCBhcyBlaXRoZXIgRXh0ZXJu YWwgb3IgRXh0ZW5kZWQKLSAgICAgIGFuZCBhcHBsaWVzIG9ubHkgdG8gbmV3IHR1cGxlczsgdGhl cmUgaXMgbm8gZWZmZWN0IG9uIGV4aXN0aW5nIHJvd3MuCisgICAgICB3ZSB0cnkgdG8gY29tcHJl c3MgbG9uZyBjb2x1bW4gdmFsdWVzIG9yIHRvIG1vdmUgaW50byBUT0FTVCB0YWJsZXMsIGFuZAor ICAgICAgaXMgYWxzbyB0aGUgdGFyZ2V0IGxlbmd0aCB3ZSB0cnkgdG8gcmVkdWNlIHRoZSBsZW5n dGggYmVsb3cgb25jZSB0b2FzdGluZworICAgICAgYmVnaW5zLiBUaGlzIGFmZmVjdHMgY29sdW1u cyBtYXJrZWQgYXMgRXh0ZXJuYWwgKGZvciBtb3ZlKSwKKyAgICAgIE1haW4gKGZvciBjb21wcmVz c2lvbiksIG9yIEV4dGVuZGVkIChmb3IgYm90aCkgYW5kIGFwcGxpZXMgb25seSB0byBuZXcKKyAg ICAgIHR1cGxlcy4gVGhlcmUgaXMgbm8gZWZmZWN0IG9uIGV4aXN0aW5nIHJvd3MuCiAgICAgICBC eSBkZWZhdWx0IHRoaXMgcGFyYW1ldGVyIGlzIHNldCB0byBhbGxvdyBhdCBsZWFzdCA0IHR1cGxl cyBwZXIgYmxvY2ssCiAgICAgICB3aGljaCB3aXRoIHRoZSBkZWZhdWx0IGJsb2NrIHNpemUgd2ls bCBiZSAyMDQwIGJ5dGVzLiBWYWxpZCB2YWx1ZXMgYXJlCiAgICAgICBiZXR3ZWVuIDEyOCBieXRl cyBhbmQgdGhlIChibG9jayBzaXplIC0gaGVhZGVyKSwgYnkgZGVmYXVsdCA4MTYwIGJ5dGVzLgo= --=_758c37f9850d8e6c2dfb5e4118a6a83b--