pgsql: Add pg_stash_advice contrib module.
| От | Robert Haas |
|---|---|
| Тема | pgsql: Add pg_stash_advice contrib module. |
| Дата | |
| Msg-id | E1w9iZi-003Ds0-1z@gemulon.postgresql.org обсуждение |
| Список | pgsql-committers |
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 <lukas@fittl.com> Reviewed-by: Alexandra Wang <alexandra.wang.oss@gmail.com> Reviewed-by: David G. Johnston <david.g.johnston@gmail.com> Reviewed-by: Jakub Wartak <jakub.wartak@enterprisedb.com> Discussion: http://postgr.es/m/CA+TgmoaeNuHXQ60P3ZZqJLrSjP3L1KYokW9kPfGbWDyt+1t=Ng@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(+)
В списке pgsql-committers по дате отправления: