Re: pgsql: Allow GRANT on pg_log_backend_memory_contexts().

2021-10-28 Thread Alvaro Herrera
On 2021-Oct-27, Jeff Davis wrote: > Above the table of functions it already says: > > "Use of these functions is restricted to superusers by default but > access may be granted to others using GRANT, with noted exceptions." > > It looks like several people missed that, so perhaps we should get r

pgsql: Improve contrib/amcheck's tests for CREATE INDEX CONCURRENTLY.

2021-10-28 Thread Tom Lane
Improve contrib/amcheck's tests for CREATE INDEX CONCURRENTLY. Commits fdd965d07 and 3cd9c3b92 tested CREATE INDEX CONCURRENTLY by launching two separate pgbench runs concurrently. This was needed so that only a single client thread would run CREATE INDEX CONCURRENTLY, avoiding deadlock between t

pgsql: Improve contrib/amcheck's tests for CREATE INDEX CONCURRENTLY.

2021-10-28 Thread Tom Lane
Improve contrib/amcheck's tests for CREATE INDEX CONCURRENTLY. Commits fdd965d07 and 3cd9c3b92 tested CREATE INDEX CONCURRENTLY by launching two separate pgbench runs concurrently. This was needed so that only a single client thread would run CREATE INDEX CONCURRENTLY, avoiding deadlock between t

pgsql: Improve contrib/amcheck's tests for CREATE INDEX CONCURRENTLY.

2021-10-28 Thread Tom Lane
Improve contrib/amcheck's tests for CREATE INDEX CONCURRENTLY. Commits fdd965d07 and 3cd9c3b92 tested CREATE INDEX CONCURRENTLY by launching two separate pgbench runs concurrently. This was needed so that only a single client thread would run CREATE INDEX CONCURRENTLY, avoiding deadlock between t

pgsql: Improve contrib/amcheck's tests for CREATE INDEX CONCURRENTLY.

2021-10-28 Thread Tom Lane
Improve contrib/amcheck's tests for CREATE INDEX CONCURRENTLY. Commits fdd965d07 and 3cd9c3b92 tested CREATE INDEX CONCURRENTLY by launching two separate pgbench runs concurrently. This was needed so that only a single client thread would run CREATE INDEX CONCURRENTLY, avoiding deadlock between t

pgsql: Speed up printing of integers in snprintf.c.

2021-10-28 Thread Tom Lane
Speed up printing of integers in snprintf.c. Since the only possible divisors are 8, 10, and 16, it doesn't cost much code space to replace the division loop with three copies using constant divisors. On most machines, division by a constant can be done a lot more cheaply than division by an arbi

pgsql: Speed up TAP tests of pg_receivewal

2021-10-28 Thread Michael Paquier
Speed up TAP tests of pg_receivewal This commit improves the speed of those tests by 25~30%, using some simple ideas to reduce the amount of data written by pg_receivewal: - Use a segment size of 1MB. While reducing the amount of data zeroed by pg_receivewal for the new segments, this improves th

pgsql: Add tap tests for the schema publications.

2021-10-28 Thread Amit Kapila
Add tap tests for the schema publications. This adds additional tests for commit 5a2832465f ("Allow publishing the tables of schema.). This allows testing streaming of data in tables that are published via schema publications. Author: Vignesh C, Haiying Tang Reviewed-by: Greg Nancarrow, Hou Zhiji