pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN.

Add memory/disk usage for Window aggregate nodes in EXPLAIN. This commit is similar to 1eff8279d and expands the idea to Window aggregate nodes so that users can know how much memory or disk the tuplestore used. This commit uses newly introduced tuplestore_get_stats() to inquire this information

pgsql: Fix redefinition of typedef.

Fix redefinition of typedef. Per buildfarm members sifaka and longfin, clang with -Wtypedef-redefinition warns of a duplicate typedef unless building with C11. Oversight in commit 40e2e5e92b. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/1bbf1e2f1a077905037272cd4

pgsql: pg_upgrade: Parallelize encoding conversion check.

pg_upgrade: Parallelize encoding conversion check. This commit makes use of the new task framework in pg_upgrade to parallelize the check for incompatible user-defined encoding conversions, i.e., those defined on servers older than v14. This step will now process multiple databases concurrently w

pgsql: pg_upgrade: Parallelize subscription check.

pg_upgrade: Parallelize subscription check. This commit makes use of the new task framework in pg_upgrade to parallelize the part of check_old_cluster_subscription_state() that verifies each of the subscribed tables is in the 'i' (initialize) or 'r' (ready) state. This check will now process mult

pgsql: Introduce framework for parallelizing various pg_upgrade tasks.

Introduce framework for parallelizing various pg_upgrade tasks. A number of pg_upgrade steps require connecting to every database in the cluster and running the same query in each one. When there are many databases, these steps are particularly time-consuming, especially since they are performed

pgsql: pg_upgrade: Parallelize incompatible polymorphics check.

pg_upgrade: Parallelize incompatible polymorphics check. This commit makes use of the new task framework in pg_upgrade to parallelize the check for usage of incompatible polymorphic functions, i.e., those with arguments of type anyarray/anyelement rather than the newer anycompatible variants. Thi

pgsql: pg_upgrade: Parallelize retrieving extension updates.

pg_upgrade: Parallelize retrieving extension updates. This commit makes use of the new task framework in pg_upgrade to parallelize retrieving the set of extensions that should be updated with the ALTER EXTENSION command after upgrade. This step will now process multiple databases concurrently whe

pgsql: pg_upgrade: Parallelize contrib/isn check.

pg_upgrade: Parallelize contrib/isn check. This commit makes use of the new task framework in pg_upgrade to parallelize the check for contrib/isn functions that rely on the bigint data type. This step will now process multiple databases concurrently when pg_upgrade's --jobs option is provided a v

pgsql: pg_upgrade: Parallelize WITH OIDS check.

pg_upgrade: Parallelize WITH OIDS check. This commit makes use of the new task framework in pg_upgrade to parallelize the check for tables declared WITH OIDS. This step will now process multiple databases concurrently when pg_upgrade's --jobs option is provided a value greater than 1. Reviewed-b

pgsql: pg_upgrade: Parallelize postfix operator check.

pg_upgrade: Parallelize postfix operator check. This commit makes use of the new task framework in pg_upgrade to parallelize the check for user-defined postfix operators. This step will now process multiple databases concurrently when pg_upgrade's --jobs option is provided a value greater than 1.

pgsql: pg_upgrade: Parallelize retrieving loadable libraries.

pg_upgrade: Parallelize retrieving loadable libraries. This commit makes use of the new task framework in pg_upgrade to parallelize retrieving the names of all libraries referenced by non-built-in C functions. This step will now process multiple databases concurrently when pg_upgrade's --jobs opt

pgsql: pg_upgrade: Parallelize retrieving relation information.

pg_upgrade: Parallelize retrieving relation information. This commit makes use of the new task framework in pg_upgrade to parallelize retrieving relation and logical slot information. This step will now process multiple databases concurrently when pg_upgrade's --jobs option is provided a value gr

pgsql: pg_upgrade: Parallelize data type checks.

pg_upgrade: Parallelize data type checks. This commit makes use of the new task framework in pg_upgrade to parallelize the checks for incompatible data types, i.e., data types whose on-disk format has changed, data types that have been removed, etc. This step will now process multiple databases c

pgsql: doc PG relnotes: fix SGML markup for new commit links

doc PG relnotes: fix SGML markup for new commit links Backpatch-through: 12 Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/46d277307fbeec2939e44f97d8ca01bc7b7e92b0 Modified Files -- doc/src/sgml/postgres.sgml | 1 + 1 file changed, 1 insertion(+

pgsql: doc PG relnotes: fix SGML markup for new commit links

doc PG relnotes: fix SGML markup for new commit links Backpatch-through: 12 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/d891c49286bb138dcd70df1dff83e22fa757fc84 Modified Files -- doc/src/sgml/postgres.sgml | 1 + 1 file changed, 1 insertion(+)

pgsql: doc PG relnotes: fix SGML markup for new commit links

doc PG relnotes: fix SGML markup for new commit links Backpatch-through: 12 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a01dbdb1cb8c888c4ad97eaba0e3a391a86d3edb Modified Files -- doc/src/sgml/postgres.sgml | 1 + 1 file changed, 1 insertion(+

pgsql: doc PG relnotes: fix SGML markup for new commit links

doc PG relnotes: fix SGML markup for new commit links Backpatch-through: 12 Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/011659d498357f4c0f243816140b09085422d309 Modified Files -- doc/src/sgml/postgres.sgml | 1 + 1 file changed, 1 insertion(+

pgsql: doc PG relnotes: fix SGML markup for new commit links

doc PG relnotes: fix SGML markup for new commit links Backpatch-through: 12 Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/bff6573c3ab9a9a44647508fed5ccf41f597834e Modified Files -- doc/src/sgml/postgres.sgml | 1 + 1 file changed, 1 insertion(+

pgsql: doc PG relnotes: fix SGML markup for new commit links

doc PG relnotes: fix SGML markup for new commit links Backpatch-through: 12 Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/6f4e1fc5f34efa801475696d38449e21f38943ba Modified Files -- doc/src/sgml/postgres.sgml | 1 + 1 file changed, 1 insertion(+

pgsql: doc PG relnotes: add links to commits

doc PG relnotes: add links to commits Discussion: https://postgr.es/m/zuyss5xda7hvc...@momjian.us Backpatch-through: 12 Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b0d6026f7c77458616ccad0de59c33bcd62737aa Modified Files -- doc/src/sgml/rele

pgsql: doc PG relnotes: add links to commits

doc PG relnotes: add links to commits Discussion: https://postgr.es/m/zuyss5xda7hvc...@momjian.us Backpatch-through: 12 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/3ce928fe58889e1004c686187963daba35ecd441 Modified Files -- doc/src/sgml/rele

pgsql: doc PG relnotes: add links to commits

doc PG relnotes: add links to commits Discussion: https://postgr.es/m/zuyss5xda7hvc...@momjian.us Backpatch-through: 12 Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/e1f0b541a9c551fc42e30d0af1eb3032998c90eb Modified Files -- doc/src/sgml/rele

pgsql: doc PG relnotes: add links to commits

doc PG relnotes: add links to commits Discussion: https://postgr.es/m/zuyss5xda7hvc...@momjian.us Backpatch-through: 12 Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/81978404a3960ad90f6f1531af702268e7f81864 Modified Files -- doc/src/sgml/rele

pgsql: doc PG relnotes: add links to commits

doc PG relnotes: add links to commits Discussion: https://postgr.es/m/zuyss5xda7hvc...@momjian.us Backpatch-through: 12 Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/5fd150379bbecce2a5e3798f2fce7c796eb00f73 Modified Files -- doc/src/sgml/rele

pgsql: scripts: add Perl script to add links to release notes

scripts: add Perl script to add links to release notes Reported-by: jian he Discussion: https://postgr.es/m/zuyss5xda7hvc...@momjian.us Backpatch-through: 12 Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a499f79fd01c74ec949c927fa656d689733a7c0e Modified

pgsql: scripts: add Perl script to add links to release notes

scripts: add Perl script to add links to release notes Reported-by: jian he Discussion: https://postgr.es/m/zuyss5xda7hvc...@momjian.us Backpatch-through: 12 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/257210455257aaac30001914886d422cbf34c215 Modified Files

pgsql: scripts: add Perl script to add links to release notes

scripts: add Perl script to add links to release notes Reported-by: jian he Discussion: https://postgr.es/m/zuyss5xda7hvc...@momjian.us Backpatch-through: 12 Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/ccd1ddc50750129a7900948ac28eef907bdbed51 Modified

pgsql: scripts: add Perl script to add links to release notes

scripts: add Perl script to add links to release notes Reported-by: jian he Discussion: https://postgr.es/m/zuyss5xda7hvc...@momjian.us Backpatch-through: 12 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/9052475cd9f0e0a954167d940bc776186aff9ef9 Modified

pgsql: scripts: add Perl script to add links to release notes

scripts: add Perl script to add links to release notes Reported-by: jian he Discussion: https://postgr.es/m/zuyss5xda7hvc...@momjian.us Backpatch-through: 12 Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/63357b6c7f631131488b8af83d10d9dedfdccaab Modified

pgsql: scripts: add Perl script to add links to release notes

scripts: add Perl script to add links to release notes Reported-by: jian he Discussion: https://postgr.es/m/zuyss5xda7hvc...@momjian.us Backpatch-through: 12 Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/dab80b93037c3eb6cef4a1d835d36364980cdf6a Modified

pgsql: scripts: add Perl script to add links to release notes

scripts: add Perl script to add links to release notes Reported-by: jian he Discussion: https://postgr.es/m/zuyss5xda7hvc...@momjian.us Backpatch-through: 12 Branch -- REL_17_STABLE Details --- https://git.postgresql.org/pg/commitdiff/054a23b67402767ec23452a9ff512025a62a80f8 Modified

Re: pgsql: Perl scripts: eliminate "Useless interpolation" warnings

On 2024-09-15 Su 9:28 PM, Bruce Momjian wrote: On Sun, Sep 15, 2024 at 06:07:21PM -0400, Andrew Dunstan wrote: On 2024-09-15 Su 4:36 PM, Bruce Momjian wrote: On Sun, Sep 15, 2024 at 04:33:49PM -0400, Andrew Dunstan wrote: I understand perfectly what the warning is about. But the project's pe