Re: Add a description to the documentation that toast_tuple_target affects "Main"

Fujii Masao <masao.fujii@oss.nttdata.com>

From: Fujii Masao <masao.fujii@oss.nttdata.com>
To: Kasahara Tatsuhito <kasahara.tatsuhito@gmail.com>, Shinya Okano <btokanosn@oss.nttdata.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2020-10-13T16:30:06Z
Lists: pgsql-hackers

On 2020/10/13 10:40, Kasahara Tatsuhito wrote:
> Hi,
> 
> On Fri, Oct 9, 2020 at 5:44 PM Shinya Okano <btokanosn@oss.nttdata.com> wrote:
>>
>> 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.
> +1

+1

+      we try to compress long column values or to move into TOAST tables, and

"we try to compress and/or move long column values into TOAST tables, and" is better?

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION



Commits

  1. doc: Mention that toast_tuple_target affects also column marked as Main.