Add pg_stash_advice contrib module. This module allows plan advice strings to be provided automatically from an in-memory advice stash. Advice stashes are stored in dynamic shared memory and must be recreated and repopulated after a server restart. If pg_stash_advice.stash_name is set to the name of an advice stash, and if query identifiers are enabled, the query identifier for each query will be looked up in the advice stash and the associated advice string, if any, will be used each time that query is planned.
Reviewed-by: Lukas Fittl <[email protected]> Reviewed-by: Alexandra Wang <[email protected]> Reviewed-by: David G. Johnston <[email protected]> Reviewed-by: Jakub Wartak <[email protected]> Discussion: http://postgr.es/m/CA+TgmoaeNuHXQ60P3ZZqJLrSjP3L1KYokW9kPfGbWDyt+1t=n...@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/e8ec19aa321abc89fb4fd277c994f14680ba17db Modified Files -------------- contrib/Makefile | 1 + contrib/meson.build | 1 + contrib/pg_stash_advice/Makefile | 27 + .../pg_stash_advice/expected/pg_stash_advice.out | 331 +++++++++++ .../expected/pg_stash_advice_utf8.out | 16 + .../expected/pg_stash_advice_utf8_1.out | 8 + contrib/pg_stash_advice/meson.build | 37 ++ contrib/pg_stash_advice/pg_stash_advice--1.0.sql | 43 ++ contrib/pg_stash_advice/pg_stash_advice.c | 605 +++++++++++++++++++++ contrib/pg_stash_advice/pg_stash_advice.control | 5 + contrib/pg_stash_advice/pg_stash_advice.h | 99 ++++ contrib/pg_stash_advice/sql/pg_stash_advice.sql | 150 +++++ .../pg_stash_advice/sql/pg_stash_advice_utf8.sql | 16 + contrib/pg_stash_advice/stashfuncs.c | 306 +++++++++++ doc/src/sgml/contrib.sgml | 1 + doc/src/sgml/filelist.sgml | 1 + doc/src/sgml/pgstashadvice.sgml | 216 ++++++++ src/tools/pgindent/typedefs.list | 6 + 18 files changed, 1869 insertions(+)
