Horton

pg_stash_advice: Allow stashed advice to be persisted to disk.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: c10edb102ada607eb054bc9e23690109d86849ef
Author: Robert Haas <rhaas@postgresql.org>
Date: 2026-04-07T14:11:36Z
Releases: 19 (unreleased) 
pg_stash_advice: Allow stashed advice to be persisted to disk.

If pg_stash_advice.persist = true, stashed advice will be written to
pg_stash_advice.tsv in the data directory, periodically and at
shutdown. On restart, stash modifications are locked out until this
file has been reloaded, but queries will not be, so there may be a
short window after startup during which previously-stashed advice is
not automatically applied.

Author: Robert Haas <rhaas@postgresql.org>
Co-authored-by: Lukas Fittl <lukas@fittl.com>
Discussion: https://postgr.es/m/CA+Tgmob87qsWa-VugofU6epuV0H5XjWZGMbQas4Q-ADKmvSyBg@mail.gmail.com

Files

PathChange+/−
contrib/pg_stash_advice/Makefile modified +3 −1
contrib/pg_stash_advice/meson.build modified +7 −1
contrib/pg_stash_advice/pg_stash_advice--1.0.sql modified +6 −0
contrib/pg_stash_advice/pg_stash_advice.c modified +169 −1
contrib/pg_stash_advice/pg_stash_advice.h modified +12 −0
contrib/pg_stash_advice/stashfuncs.c modified +41 −0
contrib/pg_stash_advice/stashpersist.c added +800 −0
contrib/pg_stash_advice/t/001_persist.pl added +84 −0
doc/src/sgml/pgstashadvice.sgml modified +66 −4
src/tools/pgindent/typedefs.list modified +4 −0

Discussion