Chris Flood cjf2xn
cjf2xn
/ dead_toast_tuples.sql
Last active
November 23, 2021 12:45
Postgres: Rewriting Existing Values Generate Dead TOAST Tuples
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 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 |