pgsql: Fix slow animal timeouts in 032_relfilenode_reuse.pl.

2022-05-13 Thread Thomas Munro
Fix slow animal timeouts in 032_relfilenode_reuse.pl. Per BF animal chipmunk: CREATE DATABASE could apparently fail due to an AV process being in the template database and not quitting fast enough for the 5 second timeout in CountOtherDBBackends(). The test script had autovacuum_naptime=1s to en

pgsql: Fix comment in pg_proc.c

2022-05-13 Thread Michael Paquier
Fix comment in pg_proc.c pgstat_create_function() creates stats for a function in a transactional fashion, so the stats would be dropped if transaction creating the function is aborted, not committed. Author: Amul Sul Discussion: https://postgr.es/m/caaj_b97x1t3xgamwnj4w7ksgn0ntug-vlrqj4nb-dsnr0

pgsql: Clean up newlines following left parentheses

2022-05-13 Thread Alvaro Herrera
Clean up newlines following left parentheses Like commit c9d297751959. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c4f113e8fef900e9e7e7c77a3a21db1535e5be72 Modified Files -- src/backend/executor/nodeAgg.c | 4 ++-- src/backend/replic

pgsql: relnotes: add null logical replication item

2022-05-13 Thread Bruce Momjian
relnotes: add null logical replication item Also move system view item to logical replication, mention "infinite _error_ loops". Reported-by: Euler Taveira, Takamichi Osumi, Amit Langote Discussion: https://postgr.es/m/21e8ef3b-6ffb-49d8-867f-4622a4dff...@www.fastmail.com Branch -- master

pgsql: Rename JsonIsPredicate.value_type, fix JSON backend/nodes/ infra

2022-05-13 Thread Tom Lane
Rename JsonIsPredicate.value_type, fix JSON backend/nodes/ infrastructure. I started out with the intention to rename value_type to item_type to avoid a collision with a typedef name that appears on some platforms. Along the way, I noticed that the adjacent field "format" was not being correctly

pgsql: Indent protocol.sgml

2022-05-13 Thread Peter Eisentraut
Indent protocol.sgml protocol.sgml had some unusual indentation that kept getting added on to with new additions in that file. This reindents it to be more in line with the style elsewhere. Discussion: https://www.postgresql.org/message-id/flat/15113594-649b-ce82-24c8-7522f1373da4%40enterprised

pgsql: Add a new shmem_request_hook hook.

2022-05-13 Thread Robert Haas
Add a new shmem_request_hook hook. Currently, preloaded libraries are expected to request additional shared memory and LWLocks in _PG_init(). However, it is not unusal for such requests to depend on MaxBackends, which won't be initialized at that time. Such requests could also depend on GUCs tha

pgsql: Doc: Improve description of the "parallel_commit" option for pos

2022-05-13 Thread Etsuro Fujita
Doc: Improve description of the "parallel_commit" option for postgres_fdw. It wasn't very clear that if this option was enabled, postgres_fdw would commit remote transactions in parallel at main-transaction end, and commit remote subtransactions in parallel at subtransaction end, due to the refere