pgsql: Add two attributes to pg_stat_database for parallel workers acti

2024-11-10 Thread Michael Paquier
Add two attributes to pg_stat_database for parallel workers activity Two attributes are added to pg_stat_database: * parallel_workers_to_launch, counting the total number of parallel workers that were planned to be launched. * parallel_workers_launched, counting the total number of parallel worker

Re: pgsql: Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21.

2024-11-10 Thread Andrew Dunstan
On Mon, Nov 11, 2024 at 10:25 AM Andrew Dunstan wrote: > > > On Mon, Nov 11, 2024 at 5:11 AM Tom Lane wrote: > >> Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21. >> >> Branch >> -- >> REL_17_STABLE >> >> Details >> --- >> >> https://git.postgresql.org/pg/commitdiff/ca19f881b071f

pgsql: pg_stat_statements: Avoid some locking during PGSS entry scans

2024-11-10 Thread Michael Paquier
pg_stat_statements: Avoid some locking during PGSS entry scans A single PGSS entry's spinlock is used to be able to modify "counters" without holding pgss->lock exclusively, as mentioned at the top of pg_stat_statements.c and within pgssEntry. Within a single pgssEntry, stats_since and minmax_sta

Re: pgsql: Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21.

2024-11-10 Thread Andrew Dunstan
On Mon, Nov 11, 2024 at 5:11 AM Tom Lane wrote: > Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21. > > Branch > -- > REL_17_STABLE > > Details > --- > > https://git.postgresql.org/pg/commitdiff/ca19f881b071fa57ee469fbc27b520fbb0c67280 > > Modified Files > -- > doc/src/

pgsql: jit: Remove obsolete LLVM version guard.

2024-11-10 Thread Thomas Munro
jit: Remove obsolete LLVM version guard. Commit 9044fc1d needed a version guard when back-patched, but it is redundant in master as of commit 972c2cd2, and I accidentally left it in there. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/29d66b2d2f80dba0ac7fa5453d4da

Re: pgsql: Fix our Windows stat() emulation to handle file sizes > 4GB.

2024-11-10 Thread Thomas Munro
On Sun, Nov 10, 2024 at 8:12 PM Andrew Dunstan wrote: > Oh, ouch. I guess it's too late to add those for this release. Still, an > initdb failure is not as bad as a pg_rewind failure, IMNSHO. Yeah, I don't think it's all that bad. It seems both unlikely (certain kinds of junction points with no

pgsql: Fix broken collate.icu.utf8 test in v12 branch.

2024-11-10 Thread Tom Lane
Fix broken collate.icu.utf8 test in v12 branch. collate.icu.utf8.sql is not run by default before v13, and commits 9c4757491/46d9be5ef evidently didn't bother to test it, with the completely predictable result that it was broken. We didn't have enable_incremental_sort in v12, plus EXPLAIN makes di

pgsql: Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21.

2024-11-10 Thread Tom Lane
Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21. Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/f7b1678d0c75a63899d7240dff07989aec546ace Modified Files -- doc/src/sgml/release-15.sgml | 1236 ++ 1 fi

pgsql: Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21.

2024-11-10 Thread Tom Lane
Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21. Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/7b9ec11aab362607f0ef4b9c1bbfe76172a659d4 Modified Files -- doc/src/sgml/release-12.sgml | 894 +++ 1 fi

pgsql: Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21.

2024-11-10 Thread Tom Lane
Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21. Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/f7ca23a6a3a1229ce8bab69558ed64ebdef9f67e Modified Files -- doc/src/sgml/release-16.sgml | 1385 ++ 1 fi

pgsql: Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21.

2024-11-10 Thread Tom Lane
Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21. Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/28301cd4df386c263e85b9b3b6f2c5bd74f26767 Modified Files -- doc/src/sgml/release-14.sgml | 1185 ++ 1 fi

pgsql: Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21.

2024-11-10 Thread Tom Lane
Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21. Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/088692b3cd3c56ddde25129f3a0087eee7ca3d94 Modified Files -- doc/src/sgml/release-13.sgml | 1055 ++ 1 fi

pgsql: Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21.

2024-11-10 Thread Tom Lane
Release notes for 17.1, 16.5, 15.9, 14.14, 13.17, 12.21. Branch -- REL_17_STABLE Details --- https://git.postgresql.org/pg/commitdiff/ca19f881b071fa57ee469fbc27b520fbb0c67280 Modified Files -- doc/src/sgml/release-17.sgml | 707 ++- 1 fi