pgsql: Show more-intuitive titles for psql commands \dt, \di, etc.
Show more-intuitive titles for psql commands \dt, \di, etc. If exactly one relation type is requested in a command of the \dtisv family, say "tables", "indexes", etc instead of "relations". This should cover the majority of actual uses, without creating a huge number of new translatable strings. The error messages for no matching relations are adjusted as well. In passing, invent "pg_log_error_internal()" to be used for frontend error messages that don't seem to need translation, analogously to errmsg_internal() in the backend. The implementation is a bit cheesy, being just a macro to prevent xgettext from recognizing a trigger keyword. This won't avoid a useless gettext lookup cycle at runtime --- but surely we don't care about an extra microsecond or two in what's supposed to be a can't-happen case. I (tgl) also made "pg_fatal_internal()", though it's not used in this patch. Author: Greg Sabino Mullane Reviewed-by: Tom Lane Discussion: https://postgr.es/m/cakanmm+7o93fqv-rfkgan1qnp-0d4d3jtykd+clueqjdmkd...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/a14707da564e8c94bd123f0e3a75e194fd7ef56a Modified Files -- src/bin/psql/describe.c | 65 +--- src/include/common/logging.h | 7 src/test/regress/expected/dependency.out | 2 +- src/test/regress/expected/psql.out | 42 ++--- 4 files changed, 88 insertions(+), 28 deletions(-)
pgsql: Introduce autovacuum_vacuum_max_threshold.
Introduce autovacuum_vacuum_max_threshold. One way autovacuum chooses tables to vacuum is by comparing the number of updated or deleted tuples with a value calculated using autovacuum_vacuum_threshold and autovacuum_vacuum_scale_factor. The threshold specifies the base value for comparison, and the scale factor specifies the fraction of the table size to add to it. This strategy ensures that smaller tables are vacuumed after fewer updates/deletes than larger tables, which is reasonable in many cases but can result in infrequent vacuums on very large tables. This is undesirable for a couple of reasons, such as very large tables incurring a huge amount of bloat between vacuums. This new parameter provides a way to set a limit on the value calculated with autovacuum_vacuum_threshold and autovacuum_vacuum_scale_factor so that very large tables are vacuumed more frequently. By default, it is set to 100,000,000 tuples, but it can be disabled by setting it to -1. It can also be adjusted for individual tables by changing storage parameters. Author: Nathan Bossart Co-authored-by: Frédéric Yhuel Reviewed-by: Melanie Plageman Reviewed-by: Robert Haas Reviewed-by: Laurenz Albe Reviewed-by: Michael Banck Reviewed-by: Joe Conway Reviewed-by: Sami Imseih Reviewed-by: David Rowley Reviewed-by: wenhui qiu Reviewed-by: Vinícius Abrahão Reviewed-by: Robert Treat Reviewed-by: Alena Rybakina Discussion: https://postgr.es/m/956435f8-3b2f-47a6-8756-8c54ded61802%40dalibo.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/306dc520b9dfd6014613961962a89940a431a069 Modified Files -- doc/src/sgml/config.sgml | 24 doc/src/sgml/maintenance.sgml | 6 -- doc/src/sgml/ref/create_table.sgml| 15 +++ src/backend/access/common/reloptions.c| 11 +++ src/backend/postmaster/autovacuum.c | 12 src/backend/utils/misc/guc_tables.c | 9 + src/backend/utils/misc/postgresql.conf.sample | 3 +++ src/bin/psql/tab-complete.in.c| 2 ++ src/include/postmaster/autovacuum.h | 1 + src/include/utils/rel.h | 1 + 10 files changed, 82 insertions(+), 2 deletions(-)
pgsql: injection_points: Re-enable permutation in isolation test "basic
injection_points: Re-enable permutation in isolation test "basic" This test has been disabled in 9f00edc22888 due to an instable expected output, where it would be possible for the wait step to report its result after the detach step is done. The expected output was ordered so as the detach would always report last. Isolation test permutations have the option to use markers to control the ordering for cases like this one, as documented in src/test/isolation/README. The permutation is enabled once again, this time with a marker added so as the detach step reports only once the wait step has finished, ensuring a correct output ordering. Reviewed-by: Bertrand Drouvot Discussion: https://postgr.es/m/z6mbztx5eqq6a...@paquier.xyz Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/9e020050b8fa8e184bc1d58e6a4bc1edfa76cb8c Modified Files -- .../modules/injection_points/expected/basic.out| 26 ++ src/test/modules/injection_points/specs/basic.spec | 11 + 2 files changed, 31 insertions(+), 6 deletions(-)
pgsql: doc: Update links which returned 404
doc: Update links which returned 404 Two links in the isn module documentation were pointing to tools which had been moved, resulting in 404 error responses. Update to the new URLs for the tools. The link to the Sequoia 2000 page in the history section was no longer working, and since the page is no longer available online update our link to point at the paper instead which is on a stable URL. These links exist in all versions of the documentation so backpatch to all supported branches. Author: Daniel Gustafsson Reported-by: charukiew...@protonmail.com Discussion: https://postgr.es/m/173679670185.705.856804465055...@wrigleys.postgresql.org Backpatch-through: 13 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/ee4667f0184d87a2e58822e6a9edad563fa164fd Modified Files -- doc/src/sgml/biblio.sgml | 18 ++ doc/src/sgml/history.sgml | 5 ++--- doc/src/sgml/isn.sgml | 4 ++-- 3 files changed, 22 insertions(+), 5 deletions(-)
pgsql: doc: Update links which returned 404
doc: Update links which returned 404 Two links in the isn module documentation were pointing to tools which had been moved, resulting in 404 error responses. Update to the new URLs for the tools. The link to the Sequoia 2000 page in the history section was no longer working, and since the page is no longer available online update our link to point at the paper instead which is on a stable URL. These links exist in all versions of the documentation so backpatch to all supported branches. Author: Daniel Gustafsson Reported-by: charukiew...@protonmail.com Discussion: https://postgr.es/m/173679670185.705.856804465055...@wrigleys.postgresql.org Backpatch-through: 13 Branch -- REL_17_STABLE Details --- https://git.postgresql.org/pg/commitdiff/32770ea03247bc42b38ccc53b84711e0c13d1498 Modified Files -- doc/src/sgml/biblio.sgml | 18 ++ doc/src/sgml/history.sgml | 5 ++--- doc/src/sgml/isn.sgml | 4 ++-- 3 files changed, 22 insertions(+), 5 deletions(-)
pgsql: doc: Update links which returned 404
doc: Update links which returned 404 Two links in the isn module documentation were pointing to tools which had been moved, resulting in 404 error responses. Update to the new URLs for the tools. The link to the Sequoia 2000 page in the history section was no longer working, and since the page is no longer available online update our link to point at the paper instead which is on a stable URL. These links exist in all versions of the documentation so backpatch to all supported branches. Author: Daniel Gustafsson Reported-by: charukiew...@protonmail.com Discussion: https://postgr.es/m/173679670185.705.856804465055...@wrigleys.postgresql.org Backpatch-through: 13 Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/ceeae767042f67e548c8792262aa9f7aefb58d00 Modified Files -- doc/src/sgml/biblio.sgml | 18 ++ doc/src/sgml/history.sgml | 5 ++--- doc/src/sgml/isn.sgml | 4 ++-- 3 files changed, 22 insertions(+), 5 deletions(-)
pgsql: doc: Update links which returned 404
doc: Update links which returned 404 Two links in the isn module documentation were pointing to tools which had been moved, resulting in 404 error responses. Update to the new URLs for the tools. The link to the Sequoia 2000 page in the history section was no longer working, and since the page is no longer available online update our link to point at the paper instead which is on a stable URL. These links exist in all versions of the documentation so backpatch to all supported branches. Author: Daniel Gustafsson Reported-by: charukiew...@protonmail.com Discussion: https://postgr.es/m/173679670185.705.856804465055...@wrigleys.postgresql.org Backpatch-through: 13 Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/5a874c671f373ecca58139d16d8f453d4d6ad222 Modified Files -- doc/src/sgml/biblio.sgml | 18 ++ doc/src/sgml/history.sgml | 5 ++--- doc/src/sgml/isn.sgml | 4 ++-- 3 files changed, 22 insertions(+), 5 deletions(-)
pgsql: doc: Update links which returned 404
doc: Update links which returned 404 Two links in the isn module documentation were pointing to tools which had been moved, resulting in 404 error responses. Update to the new URLs for the tools. The link to the Sequoia 2000 page in the history section was no longer working, and since the page is no longer available online update our link to point at the paper instead which is on a stable URL. These links exist in all versions of the documentation so backpatch to all supported branches. Author: Daniel Gustafsson Reported-by: charukiew...@protonmail.com Discussion: https://postgr.es/m/173679670185.705.856804465055...@wrigleys.postgresql.org Backpatch-through: 13 Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b26a3bc2f62433d1a8bc9ec9a7f8c52cc7a1677c Modified Files -- doc/src/sgml/biblio.sgml | 18 ++ doc/src/sgml/history.sgml | 5 ++--- doc/src/sgml/isn.sgml | 4 ++-- 3 files changed, 22 insertions(+), 5 deletions(-)
pgsql: doc: Update links which returned 404
doc: Update links which returned 404 Two links in the isn module documentation were pointing to tools which had been moved, resulting in 404 error responses. Update to the new URLs for the tools. The link to the Sequoia 2000 page in the history section was no longer working, and since the page is no longer available online update our link to point at the paper instead which is on a stable URL. These links exist in all versions of the documentation so backpatch to all supported branches. Author: Daniel Gustafsson Reported-by: charukiew...@protonmail.com Discussion: https://postgr.es/m/173679670185.705.856804465055...@wrigleys.postgresql.org Backpatch-through: 13 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/dc32ba249bff8244a6efa151c41483160888183d Modified Files -- doc/src/sgml/biblio.sgml | 18 ++ doc/src/sgml/history.sgml | 5 ++--- doc/src/sgml/isn.sgml | 4 ++-- 3 files changed, 22 insertions(+), 5 deletions(-)
