pgsql: doc PG relnotes: add paragraph explaining the section symbol

2024-09-18 Thread Bruce Momjian
doc PG relnotes: add paragraph explaining the section symbol And suppress the symbol in print mode, where the section symbol does not appear. Discussion: https://postgr.es/m/zuobilbmggetx...@momjian.us Backpatch-through: 12 Branch -- REL_17_STABLE Details --- https://git.postgresql.or

pgsql: doc PG relnotes: add paragraph explaining the section symbol

2024-09-18 Thread Bruce Momjian
doc PG relnotes: add paragraph explaining the section symbol And suppress the symbol in print mode, where the section symbol does not appear. Discussion: https://postgr.es/m/zuobilbmggetx...@momjian.us Backpatch-through: 12 Branch -- REL_13_STABLE Details --- https://git.postgresql.or

pgsql: doc PG relnotes: add paragraph explaining the section symbol

2024-09-18 Thread Bruce Momjian
doc PG relnotes: add paragraph explaining the section symbol And suppress the symbol in print mode, where the section symbol does not appear. Discussion: https://postgr.es/m/zuobilbmggetx...@momjian.us Backpatch-through: 12 Branch -- REL_16_STABLE Details --- https://git.postgresql.or

pgsql: doc PG relnotes: add paragraph explaining the section symbol

2024-09-18 Thread Bruce Momjian
doc PG relnotes: add paragraph explaining the section symbol And suppress the symbol in print mode, where the section symbol does not appear. Discussion: https://postgr.es/m/zuobilbmggetx...@momjian.us Backpatch-through: 12 Branch -- REL_14_STABLE Details --- https://git.postgresql.or

pgsql: doc PG relnotes: add paragraph explaining the section symbol

2024-09-18 Thread Bruce Momjian
doc PG relnotes: add paragraph explaining the section symbol And suppress the symbol in print mode, where the section symbol does not appear. Discussion: https://postgr.es/m/zuobilbmggetx...@momjian.us Backpatch-through: 12 Branch -- REL_15_STABLE Details --- https://git.postgresql.or

pgsql: doc PG relnotes: add paragraph explaining the section symbol

2024-09-18 Thread Bruce Momjian
doc PG relnotes: add paragraph explaining the section symbol And suppress the symbol in print mode, where the section symbol does not appear. Discussion: https://postgr.es/m/zuobilbmggetx...@momjian.us Backpatch-through: 12 Branch -- master Details --- https://git.postgresql.org/pg/co

pgsql: doc PG relnotes: add paragraph explaining the section symbol

2024-09-18 Thread Bruce Momjian
doc PG relnotes: add paragraph explaining the section symbol And suppress the symbol in print mode, where the section symbol does not appear. Discussion: https://postgr.es/m/zuobilbmggetx...@momjian.us Backpatch-through: 12 Branch -- REL_12_STABLE Details --- https://git.postgresql.or

pgsql: doc PG relnotes: no relnote footnotes for commit links in PDF

2024-09-18 Thread Bruce Momjian
doc PG relnotes: no relnote footnotes for commit links in PDF In print output, there are too many commit links for footnotes in the release notes to be useful. Reported-by: Tom Lane Discussion: https://postgr.es/m/1709858.1726618...@sss.pgh.pa.us Backpatch-through: 12 Branch -- REL_13_STAB

pgsql: doc PG relnotes: no relnote footnotes for commit links in PDF

2024-09-18 Thread Bruce Momjian
doc PG relnotes: no relnote footnotes for commit links in PDF In print output, there are too many commit links for footnotes in the release notes to be useful. Reported-by: Tom Lane Discussion: https://postgr.es/m/1709858.1726618...@sss.pgh.pa.us Backpatch-through: 12 Branch -- REL_16_STAB

pgsql: doc PG relnotes: no relnote footnotes for commit links in PDF

2024-09-18 Thread Bruce Momjian
doc PG relnotes: no relnote footnotes for commit links in PDF In print output, there are too many commit links for footnotes in the release notes to be useful. Reported-by: Tom Lane Discussion: https://postgr.es/m/1709858.1726618...@sss.pgh.pa.us Backpatch-through: 12 Branch -- REL_17_STAB

pgsql: doc PG relnotes: no relnote footnotes for commit links in PDF

2024-09-18 Thread Bruce Momjian
doc PG relnotes: no relnote footnotes for commit links in PDF In print output, there are too many commit links for footnotes in the release notes to be useful. Reported-by: Tom Lane Discussion: https://postgr.es/m/1709858.1726618...@sss.pgh.pa.us Backpatch-through: 12 Branch -- master Det

pgsql: doc PG relnotes: no relnote footnotes for commit links in PDF

2024-09-18 Thread Bruce Momjian
doc PG relnotes: no relnote footnotes for commit links in PDF In print output, there are too many commit links for footnotes in the release notes to be useful. Reported-by: Tom Lane Discussion: https://postgr.es/m/1709858.1726618...@sss.pgh.pa.us Backpatch-through: 12 Branch -- REL_14_STAB

pgsql: doc PG relnotes: no relnote footnotes for commit links in PDF

2024-09-18 Thread Bruce Momjian
doc PG relnotes: no relnote footnotes for commit links in PDF In print output, there are too many commit links for footnotes in the release notes to be useful. Reported-by: Tom Lane Discussion: https://postgr.es/m/1709858.1726618...@sss.pgh.pa.us Backpatch-through: 12 Branch -- REL_12_STAB

pgsql: Add TOAST table to pg_index.

2024-09-18 Thread Nathan Bossart
Add TOAST table to pg_index. This change allows pg_index rows to use out-of-line storage for the "indexprs" and "indpred" columns, which enables use-cases such as very large index expressions. This system catalog was previously not given a TOAST table due to a fear of circularity issues (see comm

pgsql: Optimize tuplestore usage for WITH RECURSIVE CTEs

2024-09-18 Thread David Rowley
Optimize tuplestore usage for WITH RECURSIVE CTEs nodeRecursiveunion.c makes use of two tuplestores and, until now, would delete and recreate one of these tuplestores after every recursive iteration. Here we adjust that behavior and instead reuse one of the existing tuplestores and just empty it

pgsql: Introduce ATT_PARTITIONED_TABLE in tablecmds.c

2024-09-18 Thread Michael Paquier
Introduce ATT_PARTITIONED_TABLE in tablecmds.c Partitioned tables and normal tables have been relying on ATT_TABLE in ATSimplePermissions() to produce error messages that depend on the relation's relkind, because both relkinds currently support the same set of ALTER TABLE subcommands. A patch to

pgsql: Update list of acknowledgments in release notes

2024-09-18 Thread Peter Eisentraut
Update list of acknowledgments in release notes current through 2370582ab14 Branch -- REL_17_STABLE Details --- https://git.postgresql.org/pg/commitdiff/633b609e1c239968e80a645951a28fcded53e44b Modified Files -- doc/src/sgml/release-17.sgml | 6 ++ 1 file changed, 6 inser

Re: pgsql: Don't enter parallel mode when holding interrupts.

2024-09-18 Thread Laurenz Albe
On Wed, 2024-09-18 at 02:58 +, Noah Misch wrote: > Don't enter parallel mode when holding interrupts. > > Doing so caused the leader to hang in wait_event=ParallelFinish, which > required an immediate shutdown to resolve.  Back-patch to v12 (all > supported versions). > > Francesco Degrassi >

pgsql: docs: Improve the description of num_timed column in pg_stat_che

2024-09-18 Thread Fujii Masao
docs: Improve the description of num_timed column in pg_stat_checkpointer. The previous documentation stated that num_timed reflects the number of scheduled checkpoints performed. However, checkpoints may be skipped if the server has been idle, and num_timed counts both skipped and completed check

pgsql: docs: Improve the description of num_timed column in pg_stat_che

2024-09-18 Thread Fujii Masao
docs: Improve the description of num_timed column in pg_stat_checkpointer. The previous documentation stated that num_timed reflects the number of scheduled checkpoints performed. However, checkpoints may be skipped if the server has been idle, and num_timed counts both skipped and completed check

pgsql: psql: Clean up more aggressively state of \bind[_named], \parse

2024-09-18 Thread Michael Paquier
psql: Clean up more aggressively state of \bind[_named], \parse and \close This fixes a couple of issues with the psql meta-commands mentioned above when called repeatedly: - The statement name is reset for each call. If a command errors out, its send_mode would still be set, causing an incorrect

pgsql: doc PG relnotes: no relnote footnotes for commit links in PDF

2024-09-18 Thread Bruce Momjian
doc PG relnotes: no relnote footnotes for commit links in PDF In print output, there are too many commit links for footnotes in the release notes to be useful. Reported-by: Tom Lane Discussion: https://postgr.es/m/1709858.1726618...@sss.pgh.pa.us Backpatch-through: 12 Branch -- REL_15_STAB