Re: pgsql: Implement pg_wal_replay_wait() stored procedure

2024-09-20 Thread Alexander Korotkov
On Thu, Sep 19, 2024 at 3:47 PM Alexander Korotkov wrote: > On Tue, Sep 3, 2024 at 4:07 PM Alexander Korotkov > wrote: > > On the other hand, I see that returning status could make sense for > > certain use cases. I think I could write two patches to provide that. > > 1. Make WaitForLSNReplay()

pgsql: Fix nbtree pgstats accounting with parallel scans.

2024-09-20 Thread Peter Geoghegan
Fix nbtree pgstats accounting with parallel scans. Commit 5bf748b8, which enhanced nbtree ScalarArrayOp execution, made parallel index scans work with the new design for arrays via explicit scheduling of primitive index scans. Under this scheme a parallel index scan with array keys will perform t

pgsql: Fix nbtree pgstats accounting with parallel scans.

2024-09-20 Thread Peter Geoghegan
Fix nbtree pgstats accounting with parallel scans. Commit 5bf748b8, which enhanced nbtree ScalarArrayOp execution, made parallel index scans work with the new design for arrays via explicit scheduling of primitive index scans. Under this scheme a parallel index scan with array keys will perform t

pgsql: doc PG 17 relnotes: add major features list

2024-09-20 Thread Bruce Momjian
doc PG 17 relnotes: add major features list Reported-by: Tom Lane Discussion: https://postgr.es/m/d1748552-31f5-4f80-937b-767b5f7d8...@postgresql.org Author: Jonathan Katz Backpatch-through: 17 only Branch -- REL_17_STABLE Details --- https://git.postgresql.org/pg/commitdiff/1d7cef2

pgsql: Doc: update 17.0 release date.

2024-09-20 Thread Tom Lane
Doc: update 17.0 release date. Also some trivial copy-editing. Branch -- REL_17_STABLE Details --- https://git.postgresql.org/pg/commitdiff/64b61fa5d7807a98b5a51024960698894799d936 Modified Files -- doc/src/sgml/release-17.sgml | 8 1 file changed, 4 insertions(+), 4

Re: pgsql: Handle equality operator in contrib/pg_trgm

2024-09-20 Thread Laurenz Albe
On Sun, 2020-11-15 at 05:53 +, Alexander Korotkov wrote: > Handle equality operator in contrib/pg_trgm > > Obviously, in order to equality operator be satisfiable, target string must > contain all the trigrams of the search string.  On this base, we implement > equality operator in GiST/GIN in

pgsql: Alphabetize #include directives in pg_checksums.c.

2024-09-20 Thread Nathan Bossart
Alphabetize #include directives in pg_checksums.c. Author: Michael Banck Discussion: https://postgr.es/m/66edaed0.050a0220.32a9ba.42c8%40mx.google.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/afb03e2ebf595c057db0372f543f9f796effaadf Modified Files --

pgsql: Improve Asserts checking relation matching in parallel scans.

2024-09-20 Thread Tom Lane
Improve Asserts checking relation matching in parallel scans. table_beginscan_parallel and index_beginscan_parallel contain Asserts checking that the relation a worker will use in a parallel scan is the same one the leader intended. However, they were checking for relation OID match, which was no

pgsql: Doc: explain how to test ADMIN privilege with pg_has_role().

2024-09-20 Thread Tom Lane
Doc: explain how to test ADMIN privilege with pg_has_role(). This has always been possible, but the syntax is a bit obscure, and our user-facing docs were not very helpful. Spell it out more clearly. Per complaint from Dominique Devienne. Back-patch to all supported branches. Discussion: http

pgsql: Doc: explain how to test ADMIN privilege with pg_has_role().

2024-09-20 Thread Tom Lane
Doc: explain how to test ADMIN privilege with pg_has_role(). This has always been possible, but the syntax is a bit obscure, and our user-facing docs were not very helpful. Spell it out more clearly. Per complaint from Dominique Devienne. Back-patch to all supported branches. Discussion: http

pgsql: Doc: explain how to test ADMIN privilege with pg_has_role().

2024-09-20 Thread Tom Lane
Doc: explain how to test ADMIN privilege with pg_has_role(). This has always been possible, but the syntax is a bit obscure, and our user-facing docs were not very helpful. Spell it out more clearly. Per complaint from Dominique Devienne. Back-patch to all supported branches. Discussion: http

pgsql: Doc: explain how to test ADMIN privilege with pg_has_role().

2024-09-20 Thread Tom Lane
Doc: explain how to test ADMIN privilege with pg_has_role(). This has always been possible, but the syntax is a bit obscure, and our user-facing docs were not very helpful. Spell it out more clearly. Per complaint from Dominique Devienne. Back-patch to all supported branches. Discussion: http

pgsql: Doc: explain how to test ADMIN privilege with pg_has_role().

2024-09-20 Thread Tom Lane
Doc: explain how to test ADMIN privilege with pg_has_role(). This has always been possible, but the syntax is a bit obscure, and our user-facing docs were not very helpful. Spell it out more clearly. Per complaint from Dominique Devienne. Back-patch to all supported branches. Discussion: http

pgsql: Doc: explain how to test ADMIN privilege with pg_has_role().

2024-09-20 Thread Tom Lane
Doc: explain how to test ADMIN privilege with pg_has_role(). This has always been possible, but the syntax is a bit obscure, and our user-facing docs were not very helpful. Spell it out more clearly. Per complaint from Dominique Devienne. Back-patch to all supported branches. Discussion: http

pgsql: Doc: explain how to test ADMIN privilege with pg_has_role().

2024-09-20 Thread Tom Lane
Doc: explain how to test ADMIN privilege with pg_has_role(). This has always been possible, but the syntax is a bit obscure, and our user-facing docs were not very helpful. Spell it out more clearly. Per complaint from Dominique Devienne. Back-patch to all supported branches. Discussion: http