pgsql: Parameter toast_tuple_target controls TOAST for new rows

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Parameter toast_tuple_target controls TOAST for new rows
Date: 2017-11-19 22:52:08
Message-ID: E1eGYRc-0004AR-Ok@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Parameter toast_tuple_target controls TOAST for new rows

Specifies the point at which we try to move long column values
into TOAST tables.

No effect on existing rows.

Discussion: https://postgr.es/m/CANP8+jKsVmw6CX6YP9z7zqkTzcKV1+Uzr3XjKcZW=2Ya00OyQQ@mail.gmail.com

Author: Simon Riggs <simon(at)2ndQudrant(dot)com>
Reviewed-by: Andrew Dunstan <andrew(dot)dunstan(at)2ndQuadrant(dot)com>

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/c2513365a0a85e77d3c21adb92fe12cfbe0d1897

Modified Files
--------------
doc/src/sgml/ref/alter_table.sgml | 2 +-
doc/src/sgml/ref/create_table.sgml | 21 +++++++++++++++
src/backend/access/common/reloptions.c | 12 +++++++++
src/backend/access/heap/tuptoaster.c | 2 +-
src/include/utils/rel.h | 9 +++++++
src/test/regress/expected/strings.out | 47 ++++++++++++++++++++++++++++++++++
src/test/regress/sql/strings.sql | 19 ++++++++++++++
7 files changed, 110 insertions(+), 2 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2017-11-20 00:06:15 Re: pgsql: Remove BufFile's isTemp flag.
Previous Message Tom Lane 2017-11-19 22:00:36 Re: pgsql: Remove BufFile's isTemp flag.