pgsql: logical decoding: Fix handling of large old tuples with replica - Mailing list pgsql-committers

From Andres Freund
Subject pgsql: logical decoding: Fix handling of large old tuples with replica
Date
Msg-id E1acOFW-0001ZA-0i@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
logical decoding: Fix handling of large old tuples with replica identity full.

When decoding the old version of an UPDATE or DELETE change, and if that
tuple was bigger than MaxHeapTupleSize, we either Assert'ed out, or
failed in more subtle ways in non-assert builds.  Normally individual
tuples aren't bigger than MaxHeapTupleSize, with big datums toasted.
But that's not the case for the old version of a tuple for logical
decoding; the replica identity is logged as one piece. With the default
replica identity btree limits that to small tuples, but that's not the
case for FULL.

Change the tuple buffer infrastructure to separate allocate over-large
tuples, instead of always going through the slab cache.

This unfortunately requires changing the ReorderBufferTupleBuf
definition, we need to store the allocated size someplace. To avoid
requiring output plugins to recompile, don't store HeapTupleHeaderData
directly after HeapTupleData, but point to it via t_data; that leaves
rooms for the allocated size.  As there's no reason for an output plugin
to look at ReorderBufferTupleBuf->t_data.header, remove the field. It
was just a minor convenience having it directly accessible.

Reported-By: Adam Dratwiński
Discussion: CAKg6ypLd7773AOX4DiOGRwQk1TVOQKhNwjYiVjJnpq8Wo+i62Q@mail.gmail.com

Branch
------
REL9_5_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/5990a034adfe4b777b07be10bd71730f1868e48d

Modified Files
--------------
contrib/test_decoding/expected/toast.out        |  58 ++++++++++++
contrib/test_decoding/sql/toast.sql             |  37 ++++++++
src/backend/replication/logical/decode.c        |  57 +++++++-----
src/backend/replication/logical/reorderbuffer.c | 114 +++++++++++++++++-------
src/include/replication/reorderbuffer.h         |  19 ++--
5 files changed, 222 insertions(+), 63 deletions(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: logical decoding: old/newtuple in spooled UPDATE changes was swi
Next
From: Andres Freund
Date:
Subject: pgsql: logical decoding: Tell reorderbuffer about all xids.