pgsql: doc PG 18 relnotes: update to current

2025-07-29 Thread Bruce Momjian
doc PG 18 relnotes: update to current Backpatch-through: 18 only Branch -- REL_18_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a60691eb201dfaa8a2c3aec8815d08ed3371aae7 Modified Files -- doc/src/sgml/release-18.sgml | 25 + 1 file change

pgsql: doc PG 18 relnotes: update to current, add one commit

2025-06-20 Thread Bruce Momjian
doc PG 18 relnotes: update to current, add one commit Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/fa638edc74ee4be90e94a45f8489f3be9a926d7e Modified Files -- doc/src/sgml/release-18.sgml | 7 +-- 1 file changed, 5 insertions(+), 2 deletions(-)

pgsql: doc PG 18 relnotes: indent tag blocks

2025-06-20 Thread Bruce Momjian
doc PG 18 relnotes: indent tag blocks Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/d21cf31f7c3f2657d9396913c5cea91f01a88105 Modified Files -- doc/src/sgml/release-18.sgml | 4054 -- 1 file changed, 2322 insertio

pgsql: doc PG 18 relnotes: add remaining missing link tags

2025-06-20 Thread Bruce Momjian
doc PG 18 relnotes: add remaining missing link tags Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/fed7aa8f56064e3e492c9e145a3197128d6abdf7 Modified Files -- doc/src/sgml/release-18.sgml | 274 +-- 1 file changed,

pgsql: doc PG 18 relnotes: add links to command and struct tags

2025-06-19 Thread Bruce Momjian
doc PG 18 relnotes: add links to command and struct tags Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/a8360f074cc03a7cb73a4aaa6d8caab0e0bf0a0f Modified Files -- doc/src/sgml/release-18.sgml | 78 ++-- 1 file cha

pgsql: doc PG 18 relnotes: add links for applications

2025-06-19 Thread Bruce Momjian
doc PG 18 relnotes: add links for applications Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/ed117c4c6c4feb1362abbb417ac6e6525dd8789b Modified Files -- doc/src/sgml/release-18.sgml | 64 1 file changed, 35 i

pgsql: doc: add xreflabel text for libpq and PL/Python

2025-06-19 Thread Bruce Momjian
doc: add xreflabel text for libpq and PL/Python to be used for PG 18 release notes Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/d8aa21b74ff4e3d767c3344484c3cb22b9f0ec0d Modified Files -- doc/src/sgml/libpq.sgml| 2 +- doc/src/sgml/plpython.sgml |

pgsql: doc PG 18 relnotes: add links for server variables

2025-06-18 Thread Bruce Momjian
doc PG 18 relnotes: add links for server variables Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/a03805920b36b79b7ddf97c6804117f3296b2900 Modified Files -- doc/src/sgml/release-18.sgml | 58 ++-- 1 file changed,

pgsql: doc: fix for commit 09f7d36ba16 in changing "_" to "-".

2025-06-18 Thread Bruce Momjian
doc: fix for commit 09f7d36ba16 in changing "_" to "-". I thought underscores wouldn't even work in "id"s, so I never checked to see if anything referenced it, but it seems it does work, so adjust the calling site for the dash syntax. Branch -- master Details --- https://git.postgresql.

pgsql: doc config.sgml: use "-" and not "_" for varlistentry "id"s

2025-06-18 Thread Bruce Momjian
doc config.sgml: use "-" and not "_" for varlistentry "id"s Change "id"s of file_copy_method and enable_self_join_elimination for consistency with the rest of the guc "id"s. These are new entries for PG 18. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/09f7d36ba

pgsql: doc PG 18 relnotes: add markup, still need to add links

2025-06-17 Thread Bruce Momjian
doc PG 18 relnotes: add markup, still need to add links Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/bb43c97babdf09efbd97bb535d2acb522678f977 Modified Files -- doc/src/sgml/release-18.sgml | 545 ++- 1 file chan

pgsql: doc PG 18 relnotes: add author for initdb commit 04bec894a04

2025-06-16 Thread Bruce Momjian
doc PG 18 relnotes: add author for initdb commit 04bec894a04 Needed to run src/tools//add_commit_links.pl. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/23c67e8a839441c9d6a307b531a3369b677c91eb Modified Files -- doc/src/sgml/release-18.sgml | 3 ++- 1

pgsql: doc PG 18 relnotes: add AFTER trigger user change item

2025-06-07 Thread Bruce Momjian
doc PG 18 relnotes: add AFTER trigger user change item Reported-by: Noah Misch Discussion: https://postgr.es/m/20250603172123.5f.nmi...@google.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/73e26cbeb5927053eea4e209e5eda34a30c353f1 Modified Files

pgsql: doc PG 18 relnotes: adjust wording of initdb item 48814415d5a

2025-06-07 Thread Bruce Momjian
doc PG 18 relnotes: adjust wording of initdb item 48814415d5a And move to the top of the incompatibility list. This will impact users more than any other incompatibility item because of pg_upgrade. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/37e5f0b61fa8aad82a

pgsql: doc PG 18 relnotes: modify async I/O item for other improvements

2025-05-29 Thread Bruce Momjian
doc PG 18 relnotes: modify async I/O item for other improvements Add "etc." to indicate other actions will also be improved by asynchronous I/O. Reported-by: Melanie Plageman Discussion: https://postgr.es/m/CAAKRu_bqjgSYA+OdemL-X91Yv53OwsVARZy+-tRyj8YQ=kc...@mail.gmail.com Branch -- master

pgsql: doc PG 18 relnotes: split apart log_connections item

2025-05-28 Thread Bruce Momjian
doc PG 18 relnotes: split apart log_connections item Also add details to asynchronous I/O item. Reported-by: Melanie Plageman Discussion: https://postgr.es/m/CAAKRu_YsVvyantS0X0Y_-vp_97=ygaoyjmxxycekr7pumah...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/c

pgsql: doc: clarify log_connections new "setup_durations" output

2025-05-28 Thread Bruce Momjian
doc: clarify log_connections new "setup_durations" output Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/089f27cf8aa4716acc5601abce4b14a372c8569e Modified Files -- doc/src/sgml/config.sgml | 12 ++-- 1 file changed, 6 insertions(+), 6 deletions(

pgsql: doc PG 18 relnotes: move ANALYZE item,split ANALYZE/EXPLAIN item

2025-05-28 Thread Bruce Momjian
doc PG 18 relnotes: move ANALYZE item,split ANALYZE/EXPLAIN item Reported-by: Yugo Nagata Author: Yugo Nagata Discussion: https://postgr.es/m/20250528232503.7db770f651c2c821c0e3c...@sraoss.co.jp Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/bf6034d00dd4c7e82fe2

pgsql: doc PG 18 relnotes: clarify multiplication item

2025-05-28 Thread Bruce Momjian
doc PG 18 relnotes: clarify multiplication item Reported-by: Dean Rasheed Author: Dean Rasheed Discussion: https://postgr.es/m/caezatcxzgu3llmzhobyys1mlpynmaus7+uupweefywsapnc...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c861092b0e0fe2393bc5

pgsql: doc PG 18 relnotes: add removal details to MD5 item

2025-05-27 Thread Bruce Momjian
doc PG 18 relnotes: add removal details to MD5 item Reported-by: Nathan Bossart Author: Nathan Bossart Discussion: https://postgr.es/m/aDXLoTcBYjfyqeTA@nathan Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/3e782ca32225e5d5219251a5a3c06698c1e824f8 Modified Files

pgsql: doc PG 18 relnotes: fix markup

2025-05-27 Thread Bruce Momjian
doc PG 18 relnotes: fix markup Reported-by: Peter Smith Discussion: https://postgr.es/m/cahut+pswz7wftpngv3bdtyk5d0egmpvz4ccnaxvj7gr_aca...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/08b8aa1748400ca7dcecb289ffca5e90ac33d274 Modified Files ---

pgsql: doc PG 18 relnotes: clarify btree skip-scan item

2025-05-23 Thread Bruce Momjian
doc PG 18 relnotes: clarify btree skip-scan item Reported-by: Peter Geoghegan Discussion: https://postgr.es/m/CAH2-Wzko57+sT=fcxhho7jnplhh35up_5aavogltj_d9bat...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/44ce4e1593b1821005b29ffaa19d9cbdd80747

pgsql: doc PG 18 relnotes: update to current

2025-05-23 Thread Bruce Momjian
doc PG 18 relnotes: update to current Includes runtime injection point item by Michael Paquier. Reported-by: Michael Paquier Author: Michael Paquier Discussion: https://postgr.es/m/adas0_ewzegl4...@paquier.xyz Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/1ca5

pgsql: doc PG 18 relnotes: adjust CREATE SUBSCRIPTION attribution

2025-05-22 Thread Bruce Momjian
doc PG 18 relnotes: adjust CREATE SUBSCRIPTION attribution Reported-by: vignesh C Discussion: https://postgr.es/m/CALDaNm0Wy-vJ6dE+e=y=yuq31i2kvgf-rs-u6qog4k7tpu_...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/883339c170d1c73162283506c85536f735

pgsql: doc PG 18 relnotes: clarify btree skip scan item

2025-05-22 Thread Bruce Momjian
doc PG 18 relnotes: clarify btree skip scan item Reported-by: Peter Geoghegan Discussion: https://postgr.es/m/CAH2-Wz=2CWXgO1+uyR-VfN3ALMtFnfTtXK-VtkoQQ89ogm=4...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/7ddfac79f2cd315314efb1402e896fa4386a1

pgsql: doc PG 18 relnotes: remove duplicate commit entry

2025-05-22 Thread Bruce Momjian
doc PG 18 relnotes: remove duplicate commit entry Item related to btree skip scans. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/3b7140d27e248171fc4a9a18bdfd2288054e8bde Modified Files -- doc/src/sgml/release-18.sgml | 3 --- 1 file changed, 3 deleti

pgsql: doc PG 18 relnotes: mv. hash joins and GROUP BY item to General

2025-05-09 Thread Bruce Momjian
doc PG 18 relnotes: mv. hash joins and GROUP BY item to General Reported-by: David Rowley Discussion: https://postgr.es/m/CAApHDvqJz+Zf7a6abisqoTGottDSRD+YPx=aqsgcsckd476...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/99ddf8615c215bb81655574b9a

pgsql: doc PG 18 relnotes: fix missing parens for crc32c()

2025-05-09 Thread Bruce Momjian
doc PG 18 relnotes: fix missing parens for crc32c() Reported-by: Steven Niu Discussion: https://postgr.es/m/CABBtG=ejqk58cfwpw3etvzfqfhjc-qoqv+9gqwrnlo+p9wy...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/89372d0aaa4a6f0e560acdf9014c5ad66fdde1b1

pgsql: PG 18 relnotes: adjust RETURNING new/old item

2025-05-08 Thread Bruce Momjian
PG 18 relnotes: adjust RETURNING new/old item Reported-by: jian he Discussion: https://postgr.es/m/CACJufxFM1avdwu=ortx_umajtdbfoj1gp7mnnhooftvj9qt...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/9d710a1ac0912244934277a99fe4666df3d2b825 Modifie

pgsql: doc PG 18 relnotes: adjust pg_log_backend_memory_contexts()

2025-05-07 Thread Bruce Momjian
doc PG 18 relnotes: adjust pg_log_backend_memory_contexts() Reported-by: David Rowley Discussion: https://postgr.es/m/caaphdvrglbqs_vm9comy7ubdvudmkds7rwc20yjepf+xrty...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/9fef27a83b311265550924110783408

pgsql: doc PG 18 relnotes: add pg_log_backend_memory_contexts() mention

2025-05-07 Thread Bruce Momjian
doc PG 18 relnotes: add pg_log_backend_memory_contexts() mention Now zero-based. Reported-by: David Rowley Discussion: https://postgr.es/m/caaphdvqmftbdfwc0z-thxlnbmkjlyezdapguza7x_pudzsy...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/f8d49aa13

pgsql: doc PG 18 relnotes: adjust pgbench per-script reporting item

2025-05-07 Thread Bruce Momjian
doc PG 18 relnotes: adjust pgbench per-script reporting item Also run src/tools/add_commit_links.pl for a previous commit. Reported-by: Yugo Nagata Discussion: https://postgr.es/m/20250507195941.c6e1b48c73f062b727f68...@sraoss.co.jp Branch -- master Details --- https://git.postgresql

pgsql: doc PG 18 relnotes: mention GROUP SET fixes

2025-05-07 Thread Bruce Momjian
doc PG 18 relnotes: mention GROUP SET fixes Reported-by: Richard Guo Discussion: https://postgr.es/m/CAMbWs4_asKPqTCt0h9pp=zhc9vmpcnczbhef6xkxn1lhlap...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/3bd5271729c5496e3712c9ffbb002a6bef99a4c3 Modif

pgsql: doc PG 18 relnotes: adjust partition planning item

2025-05-06 Thread Bruce Momjian
doc PG 18 relnotes: adjust partition planning item Reported-by: David Rowley Discussion: https://postgr.es/m/caaphdvqgk7uqpzawxsfbifhvbhhb0txauxhurdwg4d5mik_...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/b560ce7884a32ba6409adab340b9732dcd21028

pgsql: doc PG 18 relnotes: small adjustments regarding options

2025-05-06 Thread Bruce Momjian
doc PG 18 relnotes: small adjustments regarding options Reported-by: jian he Discussion: https://postgr.es/m/CACJufxH1jo=hv77ak0hujybbmupmr6+jt+8g-yovujmhupg...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/ada78f9bef2eb47b0711a9eec07529c0da7c567

pgsql: doc PG 18 relnotes: move partition locking item to General Perf

2025-05-06 Thread Bruce Momjian
doc PG 18 relnotes: move partition locking item to General Perf Reported-by: Amit Langote Discussion: https://postgr.es/m/CA+HiwqE+8Pui_NCCC7zgacnet0Cf3tc_vU+P=nhldes-8xu...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/575f6003eddbaf0d08195e1e48

pgsql: doc PG 18 relnotes: adjust partition items

2025-05-06 Thread Bruce Momjian
doc PG 18 relnotes: adjust partition items Reported-by: David Rowley Discussion: https://postgr.es/m/caaphdvo+brvtxmbpjnxbtnaovjwn9+-dyc0kn7rsdqdnvpg...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/45750c6cfe8d1ba6018366642a35e661b9d6f3af Modif

pgsql: doc PG 18 relnotes: reword OAuth item

2025-05-05 Thread Bruce Momjian
doc PG 18 relnotes: reword OAuth item Reported-by: Jacob Champion Discussion: https://postgr.es/m/caoymi+meqoqbsjas5v5t__b+6h_mlxyy3jfrvjeq638fnnx...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c0e6aace02b6c47e7b99d49cc0e88918349ac30a Modified

pgsql: doc PG 18 relnotes: add mention of pg_stat_reset_backend_stats()

2025-05-05 Thread Bruce Momjian
doc PG 18 relnotes: add mention of pg_stat_reset_backend_stats() This is for WAL statistics. Reported-by: Bertrand Drouvot Discussion: https://postgr.es/m/abjglj+yi++fv...@ip-10-97-1-34.eu-west-3.compute.internal Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/0d

pgsql: doc PG 18 relnotes: adjust hash item

2025-05-05 Thread Bruce Momjian
doc PG 18 relnotes: adjust hash item Reported-by: David Rowley Discussion: https://postgr.es/m/caaphdvrnmgncngzmh2obg5k-+4d1lgjgzrz7180ochrt1vf...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/092e72a93023fc9cea9cf673ab577ccd8537fb69 Modified Fi

pgsql: doc PG 18 relnotes: split partition optimizer item into two

2025-05-05 Thread Bruce Momjian
doc PG 18 relnotes: split partition optimizer item into two Reported-by: David Rowley Discussion: https://postgr.es/m/CAApHDvohfoJ0D9eiUuVyHU_kq2Y7A_jAjWVsUt0Fm7Gw1Q=1...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/cf847d6340a6620251315fccae3bd

pgsql: doc PG 18 relnotes: adjust COPY and REJECT_LIMIT items

2025-05-04 Thread Bruce Momjian
doc PG 18 relnotes: adjust COPY and REJECT_LIMIT items Reported-by: Atsushi Torikoshi Discussion: https://postgr.es/m/CAM6-o=CEF6tKAjtGMEOd45YySwNRXPu8d_zyYq=fhnia9ho...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/b3754dcc9ff7aba2268e98ecf4b554

pgsql: doc PG 18 relnotes: move and clarify constraint items

2025-05-04 Thread Bruce Momjian
doc PG 18 relnotes: move and clarify constraint items Reported-by: Álvaro Herrera Discussion: https://postgr.es/m/202505041135.cpo7zgdcya2u@alvherre.pgsql Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/d83981c24be76b64205158b59b6c05cf118187c3 Modified Files

pgsql: doc PG 18 relnotes: add commit for cancel key and protocol neg.

2025-05-04 Thread Bruce Momjian
doc PG 18 relnotes: add commit for cancel key and protocol neg. Reported-by: Jelte Fennema-Nio Discussion: https://postgr.es/m/CAGECzQQehQrhkNNXvLiBgE3odBbTPG=9pzv8f4oqq3koork...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/8c9eec540dc4ba684b74e

pgsql: doc PG 18 relnotes: fix libpq wording

2025-05-03 Thread Bruce Momjian
doc PG 18 relnotes: fix libpq wording Reported-by: Jelte Fennema-Nio Discussion: https://postgr.es/m/CAGECzQT4804OLOP+nDBxDpMw3Soq=g+fkoe7nrybhggy4gg...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/a675149e87706d01e4007150a0124b89bdef08be Modifi

pgsql: doc: update guidelines on non-ASCII characters in docs

2025-05-03 Thread Bruce Momjian
doc: update guidelines on non-ASCII characters in docs Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/fb21ed6c38da719149443e78048790c0347e2c9b Modified Files -- doc/src/sgml/README.non-ASCII | 9 + 1 file changed, 5 insertions(+), 4 deletions(-)

pgsql: doc PG 18 relnotes: add GROUP BY column elimination item

2025-05-03 Thread Bruce Momjian
doc PG 18 relnotes: add GROUP BY column elimination item With a nod to PG 9.6. Reported-by: jian he Discussion: https://postgr.es/m/CACJufxEqs=exzetwtaoootfhzrtxvswg8m2upfzjnts3wq6...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/24987c6f0687576

pgsql: doc PG 18 relnotes: move protocol version item to "server"

2025-05-03 Thread Bruce Momjian
doc PG 18 relnotes: move protocol version item to "server" Reported-by: Jelte Fennema-Nio Discussion: https://postgr.es/m/cageczqstbgtsdjpxohwko7106-ynnyqgzpznjdis+xtkguh...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/04b269da56db966bd439bf4634

pgsql: doc PG 18 relnotes: adjust libpq trace & potocol version items

2025-05-02 Thread Bruce Momjian
doc PG 18 relnotes: adjust libpq trace & potocol version items Reported-by: Jelte Fennema-Nio Discussion: https://postgr.es/m/cageczqqj0r_jx38fa-_kepp9uamzccujrayajg2+fpks1b8...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/9f8fcadb2087d3178dc01d

pgsql: doc PG 18 relnotes: update chapter tags for recent commit

2025-05-02 Thread Bruce Momjian
doc PG 18 relnotes: update chapter tags for recent commit Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/9fd989ff9937966a8c3f28bfb6cce8f8071b3289 Modified Files -- doc/src/sgml/release-18.sgml | 1 + 1 file changed, 1 insertion(+)

pgsql: doc PG 18 relnotes: reword and reorder items

2025-05-02 Thread Bruce Momjian
doc PG 18 relnotes: reword and reorder items Also move ssl_groups to a more appropriate section. Reported-by: Jacob Champion (ssl_groups item) Discussion: https://postgr.es/m/caoymi+k_zpgadorwv46_j-o-a_hswxcxm6h8vccq45y28de...@mail.gmail.com Branch -- master Details --- https://git.p

pgsql: doc: first draft of the PG 18 release notes

2025-05-01 Thread Bruce Momjian
doc: first draft of the PG 18 release notes Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/a724c7889f74cc4e76e1979f90808decbc744c79 Modified Files -- doc/src/sgml/release-18.sgml | 3511 +- 1 file changed, 3501 in

pgsql: doc: adjust max_files_per_process again

2025-04-29 Thread Bruce Momjian
doc: adjust max_files_per_process again Reported-by: Andres Freund Discussion: https://postgr.es/m/5yqochswkulckuzzrwgv2nqdrfh4k4coc4uwq4lvgzkfwnbjbd@46igbiwjabn2 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/faced8e6a40b469bf9603db868beb6604c95df32 Modified F

Re: pgsql: doc: clarify new behavior of max_files_per_process

2025-04-29 Thread Bruce Momjian
On Tue, Apr 29, 2025 at 10:26:50AM -0400, Bruce Momjian wrote: > On Tue, Apr 29, 2025 at 09:52:03AM -0400, Andres Freund wrote: > > Hi, > > > > On 2025-04-29 13:45:44 +, Bruce Momjian wrote: > > > doc: clarify new behavior of max_files_per_process > >

Re: pgsql: doc: clarify new behavior of max_files_per_process

2025-04-29 Thread Bruce Momjian
On Tue, Apr 29, 2025 at 09:52:03AM -0400, Andres Freund wrote: > Hi, > > On 2025-04-29 13:45:44 +0000, Bruce Momjian wrote: > > doc: clarify new behavior of max_files_per_process > > I don't think this really is an improvement - if postmaster is called with a >

pgsql: doc: clarify new behavior of max_files_per_process

2025-04-29 Thread Bruce Momjian
doc: clarify new behavior of max_files_per_process Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/9a9e60fed39268bb85b59dde3cdb0b0166c85cc5 Modified Files -- doc/src/sgml/config.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-)

pgsql: doc: improve wording of vacuum_max_eager_freeze_failure_rate

2025-04-26 Thread Bruce Momjian
doc: improve wording of vacuum_max_eager_freeze_failure_rate Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/10e8176950b14ab7710a1ea65cad3179b52edbe3 Modified Files -- doc/src/sgml/config.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-)

pgsql: doc: simplify new EXPLAIN ANALYZE BUFFERS description

2025-04-24 Thread Bruce Momjian
doc: simplify new EXPLAIN ANALYZE BUFFERS description Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/6389db23209a3a9b99759b26fbd26a9da5693116 Modified Files -- doc/src/sgml/ref/explain.sgml | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-)

Re: pgsql: Fix PG 17 [NOT] NULL optimization bug for domains

2025-04-08 Thread Bruce Momjian
On Tue, Apr 8, 2025 at 01:34:07AM +, Bruce Momjian wrote: > Fix PG 17 [NOT] NULL optimization bug for domains > > A PG 17 optimization allowed columns with NOT NULL constraints to skip > table scans for IS NULL queries, and to skip IS NOT NULL checks for IS > NOT NULL querie

pgsql: Fix PG 17 [NOT] NULL optimization bug for domains

2025-04-07 Thread Bruce Momjian
Fix PG 17 [NOT] NULL optimization bug for domains A PG 17 optimization allowed columns with NOT NULL constraints to skip table scans for IS NULL queries, and to skip IS NOT NULL checks for IS NOT NULL queries. This didn't work for domain types, since domain types don't follow the IS NULL/IS NOT N

pgsql: Fix PG 17 [NOT] NULL optimization bug for domains

2025-04-07 Thread Bruce Momjian
Fix PG 17 [NOT] NULL optimization bug for domains A PG 17 optimization allowed columns with NOT NULL constraints to skip table scans for IS NULL queries, and to skip IS NOT NULL checks for IS NOT NULL queries. This didn't work for domain types, since domain types don't follow the IS NULL/IS NOT N

Re: pgsql: Increase default maintenance_io_concurrency to 16

2025-03-18 Thread Bruce Momjian
Files > -- > doc/src/sgml/config.sgml | 8 > src/backend/utils/misc/postgresql.conf.sample | 2 +- > src/include/storage/bufmgr.h | 2 +- > 3 files changed, 6 insertions(+), 6 deletions(-) > -- Bruce Momjian

pgsql: doc: clarify default checksum behavior in non-master branches

2025-02-21 Thread Bruce Momjian
doc: clarify default checksum behavior in non-master branches Also simplify and correct data checksum wording in master now that it is the default. PG 13 did not have the awkward wording. Reported-by: Felix Reviewed-by: Laurenz Albe Discussion: https://postgr.es/m/173928241056.707.398986702

pgsql: doc: clarify default checksum behavior in non-master branches

2025-02-21 Thread Bruce Momjian
doc: clarify default checksum behavior in non-master branches Also simplify and correct data checksum wording in master now that it is the default. PG 13 did not have the awkward wording. Reported-by: Felix Reviewed-by: Laurenz Albe Discussion: https://postgr.es/m/173928241056.707.398986702

pgsql: doc: clarify default checksum behavior in non-master branches

2025-02-21 Thread Bruce Momjian
doc: clarify default checksum behavior in non-master branches Also simplify and correct data checksum wording in master now that it is the default. PG 13 did not have the awkward wording. Reported-by: Felix Reviewed-by: Laurenz Albe Discussion: https://postgr.es/m/173928241056.707.398986702

pgsql: doc: clarify default checksum behavior in non-master branches

2025-02-21 Thread Bruce Momjian
doc: clarify default checksum behavior in non-master branches Also simplify and correct data checksum wording in master now that it is the default. PG 13 did not have the awkward wording. Reported-by: Felix Reviewed-by: Laurenz Albe Discussion: https://postgr.es/m/173928241056.707.398986702

pgsql: doc: clarify default checksum behavior in non-master branches

2025-02-21 Thread Bruce Momjian
doc: clarify default checksum behavior in non-master branches Also simplify and correct data checksum wording in master now that it is the default. PG 13 did not have the awkward wording. Reported-by: Felix Reviewed-by: Laurenz Albe Discussion: https://postgr.es/m/173928241056.707.398986702

pgsql: doc: remove non-breaking space in SGML files, causes make error

2025-02-21 Thread Bruce Momjian
doc: remove non-breaking space in SGML files, causes make error Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/6ea0734e41de4f7f39c0df05736c1714aa004b61 Modified Files -- doc/src/sgml/installation.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: doc: add example of sign mismatch with POSIX/ISO-8601 time zones

2025-02-18 Thread Bruce Momjian
doc: add example of sign mismatch with POSIX/ISO-8601 time zones Author: Laurenz Albe Discussion: https://postgr.es/m/eb4d1e15c6822c1937be1491118500dd9201492f.ca...@cybertec.at Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/06dc1ffd24096f7c71d1abeaa9e96fec4db9313

pgsql: Update copyright for 2025

2025-01-01 Thread Bruce Momjian
Update copyright for 2025 Backpatch-through: 13 Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/24a1948ad2b3a9a6730bb1f084891d8d2be85fea Modified Files -- COPYRIGHT | 2 +- doc/src/sgml/legal.sgml | 6 +++--- 2 files changed, 4 insert

pgsql: Update copyright for 2025

2025-01-01 Thread Bruce Momjian
Update copyright for 2025 Backpatch-through: 13 Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/6a2440167a8b778277907e8babea1840d1c5eee0 Modified Files -- COPYRIGHT | 2 +- doc/src/sgml/legal.sgml | 6 +++--- 2 files changed, 4 insert

pgsql: Update copyright for 2025

2025-01-01 Thread Bruce Momjian
Update copyright for 2025 Backpatch-through: 13 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/73055a2bb170c0eb738d88c22ad51b662788236d Modified Files -- COPYRIGHT | 2 +- doc/src/sgml/legal.sgml | 6 +++--- 2 files changed, 4 insert

pgsql: Update copyright for 2025

2025-01-01 Thread Bruce Momjian
Update copyright for 2025 Backpatch-through: 13 Branch -- REL_17_STABLE Details --- https://git.postgresql.org/pg/commitdiff/759620716adb347c1d8c8b2e6f7d88b947a54c98 Modified Files -- COPYRIGHT | 2 +- doc/src/sgml/legal.sgml | 6 +++--- 2 files changed, 4 insert

pgsql: Update copyright for 2025

2025-01-01 Thread Bruce Momjian
Update copyright for 2025 Backpatch-through: 13 Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/c4f8291cf00a9101a80e77f0efd70b4836a4ebae Modified Files -- COPYRIGHT | 2 +- doc/src/sgml/legal.sgml | 6 +++--- 2 files changed, 4 insert

pgsql: Return actual error code from FOP failure in PDF build

2024-12-04 Thread Bruce Momjian
Return actual error code from FOP failure in PDF build Previously we returned "1" on error. Improvement on 77c189cdafe. Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/24c1c6338719e4de1dd5f045418e64957781c595 Modified Files -

pgsql: Properly use $(AWK) in Makefile, not 'awk'

2024-12-03 Thread Bruce Momjian
Properly use $(AWK) in Makefile, not 'awk' Fix for commit 498f1307569. Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/77c189cdafe3873b7273149fbc490cc11c431cc3 Modified Files -- doc/src/sgml/Makefile | 2 +- 1 file changed, 1 i

pgsql: Fix Makefile so invalid characters warning preserves error code

2024-12-03 Thread Bruce Momjian
Fix Makefile so invalid characters warning preserves error code Fix for commit e4c8865196f. Reported-by: Peter Eisentraut Discussion: https://postgr.es/m/88cb6ecf-22bb-431e-974b-1cd236a80...@eisentraut.org Backpatch-through: master Branch -- master Details --- https://git.postgresql.

pgsql: Now that we have non-Latin1 SGML detection, restore Latin1 chars

2024-12-03 Thread Bruce Momjian
Now that we have non-Latin1 SGML detection, restore Latin1 chars This reverts the change in commit 641a5b7a144 that converted them to HTML entities. Reported-by: Peter Eisentraut Discussion: https://postgr.es/m/z05ssovhewi-r...@momjian.us Backpatch-through: master Branch -- master Details

pgsql: doc Makefile: issue warning about chars that cannot be output

2024-12-02 Thread Bruce Momjian
doc Makefile: issue warning about chars that cannot be output A follow-up improvement to commit 641a5b7a144. Reported-by: Tatsuo Ishii, Tom Lane Discussion: https://postgr.es/m/20241126.182513.1752581942460106099.is...@postgresql.org Backpatch-through: master Branch -- master Details ---

pgsql: Fix commit 641a5b7a144 for "nbsp" output in SVG files

2024-11-26 Thread Bruce Momjian
Fix commit 641a5b7a144 for "nbsp" output in SVG files In commit 641a5b7a144, I removed "nbsp" characters from SVG files, not realizing the SVG files were generated from GV files and that the "nbsp" characters were caused by trailing ASCII spaces in GV files. This commit restores the "nbsp" SVG ch

pgsql: doc: clarify how logical replication takes its initial snapshot

2024-11-21 Thread Bruce Momjian
doc: clarify how logical replication takes its initial snapshot Reported-by: Koen De Groote Discussion: https://postgr.es/m/171606613152.686.7693963105919927...@wrigleys.postgresql.org Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/4c4

pgsql: doc: clarify that jsonb_path_match() returns an SQL boolean

2024-11-20 Thread Bruce Momjian
doc: clarify that jsonb_path_match() returns an SQL boolean Not a JSON boolean. Also clarify that other predicate check expressions functions return a JSON boolean, not an SQL boolean. Reported-by: jian he Discussion: https://postgr.es/m/CACJufxH7tP1NXCHN1bUBXcEB=dv7-qe+zjb3uxwk6em+9qz...@mai

pgsql: More logically order libpq func. includes, e.g., group GUC vals

2024-11-20 Thread Bruce Momjian
More logically order libpq func. includes, e.g., group GUC vals Reported-by: David Zhang Discussion: https://postgr.es/m/65909efe-97c6-4863-af4e-21eb5a26d...@highgo.ca Co-authored-by: David Zhang Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/comm

pgsql: doc: clarify that jsonb_path_match() returns an SQL boolean

2024-11-20 Thread Bruce Momjian
doc: clarify that jsonb_path_match() returns an SQL boolean Not a JSON boolean. Also clarify that other predicate check expressions functions return a JSON boolean, not an SQL boolean. Reported-by: jian he Discussion: https://postgr.es/m/CACJufxH7tP1NXCHN1bUBXcEB=dv7-qe+zjb3uxwk6em+9qz...@mai

pgsql: clarify --no-comments option in --help and SGML files

2024-11-20 Thread Bruce Momjian
clarify --no-comments option in --help and SGML files The previous commit, b38bac26e20, missed these cases for dump/restore. Reported-by: Tom Lane Discussion: https://postgr.es/m/3495698.1731968...@sss.pgh.pa.us Backpatch-through: master Branch -- master Details --- https://git.postgr

pgsql: doc: clarify pg_dump --no-comments meaning as SQL comments

2024-11-18 Thread Bruce Momjian
doc: clarify pg_dump --no-comments meaning as SQL comments Discussion: https://postgr.es/m/zyjdajesxbfpk...@momjian.us Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/b38bac26e203ffb4130a6e0f27146cb8d4bbc9c0 Modified Files --

pgsql: doc: clarify text about combining row-level policies

2024-11-18 Thread Bruce Momjian
doc: clarify text about combining row-level policies Reported-by: spl...@ya.ru Discussion: https://postgr.es/m/173045909386.700.9231055113418242...@wrigleys.postgresql.org Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/cffca3665d8238dd

Re: pgsql: doc: remove mention of ActiveState for Perl and Tcl on Windows

2024-11-05 Thread Bruce Momjian
I am not sure why this is only being posted to the lists now, and it confused me when it didn't appear after my commit. I assume I used some blocked keywords. --- On Fri, Nov 1, 2024 at 03:31:20PM +0000, Bruce Mo

pgsql: doc: remove mention of ActiveState for Perl and Tcl on Windows

2024-11-05 Thread Bruce Momjian
doc: remove mention of ActiveState for Perl and Tcl on Windows Replace with Strawberry Perl and Magicsplat Tcl. Reported-by: Yasir Hussain Discussion: https://postgr.es/m/CAA9OW9fAAM_WDYYpAquqF6j1hmfRMzHPsFkRfP5E6oSfkF=d...@mail.gmail.com Backpatch-through: 12 Branch -- REL_16_STABLE De

pgsql: doc: remove mention of ActiveState for Perl and Tcl on Windows

2024-11-05 Thread Bruce Momjian
doc: remove mention of ActiveState for Perl and Tcl on Windows Replace with Strawberry Perl and Magicsplat Tcl. Reported-by: Yasir Hussain Discussion: https://postgr.es/m/CAA9OW9fAAM_WDYYpAquqF6j1hmfRMzHPsFkRfP5E6oSfkF=d...@mail.gmail.com Backpatch-through: 12 Branch -- REL_14_STABLE De

pgsql: doc: remove mention of ActiveState for Perl and Tcl on Windows

2024-11-05 Thread Bruce Momjian
doc: remove mention of ActiveState for Perl and Tcl on Windows Replace with Strawberry Perl and Magicsplat Tcl. Reported-by: Yasir Hussain Discussion: https://postgr.es/m/CAA9OW9fAAM_WDYYpAquqF6j1hmfRMzHPsFkRfP5E6oSfkF=d...@mail.gmail.com Backpatch-through: 12 Branch -- REL_13_STABLE De

pgsql: doc: remove mention of ActiveState for Perl and Tcl on Windows

2024-11-05 Thread Bruce Momjian
doc: remove mention of ActiveState for Perl and Tcl on Windows Replace with Strawberry Perl and Magicsplat Tcl. Reported-by: Yasir Hussain Discussion: https://postgr.es/m/CAA9OW9fAAM_WDYYpAquqF6j1hmfRMzHPsFkRfP5E6oSfkF=d...@mail.gmail.com Backpatch-through: 12 Branch -- REL_12_STABLE De

pgsql: doc: remove mention of ActiveState for Perl and Tcl on Windows

2024-11-05 Thread Bruce Momjian
doc: remove mention of ActiveState for Perl and Tcl on Windows Replace with Strawberry Perl and Magicsplat Tcl. Reported-by: Yasir Hussain Discussion: https://postgr.es/m/CAA9OW9fAAM_WDYYpAquqF6j1hmfRMzHPsFkRfP5E6oSfkF=d...@mail.gmail.com Backpatch-through: 12 Branch -- master Details -

pgsql: doc: remove mention of ActiveState for Perl and Tcl on Windows

2024-11-05 Thread Bruce Momjian
doc: remove mention of ActiveState for Perl and Tcl on Windows Replace with Strawberry Perl and Magicsplat Tcl. Reported-by: Yasir Hussain Discussion: https://postgr.es/m/CAA9OW9fAAM_WDYYpAquqF6j1hmfRMzHPsFkRfP5E6oSfkF=d...@mail.gmail.com Backpatch-through: 12 Branch -- REL_17_STABLE De

pgsql: doc: remove mention of ActiveState for Perl and Tcl on Windows

2024-11-05 Thread Bruce Momjian
doc: remove mention of ActiveState for Perl and Tcl on Windows Replace with Strawberry Perl and Magicsplat Tcl. Reported-by: Yasir Hussain Discussion: https://postgr.es/m/CAA9OW9fAAM_WDYYpAquqF6j1hmfRMzHPsFkRfP5E6oSfkF=d...@mail.gmail.com Backpatch-through: 12 Branch -- REL_15_STABLE De

pgsql: doc: use more accurate URL for bug reporting

2024-11-04 Thread Bruce Momjian
doc: use more accurate URL for bug reporting Reported-by: n...@makarevitch.org Discussion: https://postgr.es/m/172947609746.699.14488791149769110...@wrigleys.postgresql.org Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/3293b718a01310c

pgsql: doc: remove check of SVG files, since they are derived

2024-11-04 Thread Bruce Momjian
doc: remove check of SVG files, since they are derived revert of change from commit 641a5b7a144 Reported-by: Peter Eisentraut Discussion: https://postgr.es/m/2c5dd601-b245-4092-9c27-6d1ad5160...@eisentraut.org Backpatch-through: master Branch -- master Details --- https://git.postgr

pgsql: doc: fix typo in mvcc clarification in commit 2fa255ce9b9

2024-11-04 Thread Bruce Momjian
doc: fix typo in mvcc clarification in commit 2fa255ce9b9 Reported-by: Erik Rijkers (private email) Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/7ac744e72c842f528bfbb303e615560f0689619b Modified Files -- doc/src/sgml/mvcc.

pgsql: doc: clarify text around MVCC example query

2024-11-01 Thread Bruce Momjian
doc: clarify text around MVCC example query Reported-by: marlene.brandstaetter@cargonet.software Discussion: https://postgr.es/m/167765529052.987840.12345375075704447...@wrigleys.postgresql.org Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/comm

pgsql: doc: remove useless MERGE example

2024-11-01 Thread Bruce Momjian
doc: remove useless MERGE example Reported-by: dwayne.tow...@gmail.com Discussion: https://postgr.es/m/167699245721.1902146.6479762301617101...@wrigleys.postgresql.org Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/4a9effe45ee96f7105ba

  1   2   3   4   5   6   7   8   9   10   >