Skip to content

Instantly share code, notes, and snippets.

@cjf2xn
cjf2xn / dead_toast_tuples.sql
Last active Nov 23, 2021
Postgres: Rewriting Existing Values Generate Dead TOAST Tuples
View dead_toast_tuples.sql
// adapted from https://www.postgresql.org/message-id/A737B7A37273E048B164557ADEF4A58B539A6ACE@ntex2010i.host.magwien.gv.at
// tested on PG 9.6.12
// create extension for viewing physical page data
CREATE EXTENSION pageinspect;
=>
CREATE EXTENSION
// create test table