pgsql: Allow adjusting session_authorization and role in parallel worke

2024-08-10 Thread Tom Lane
Allow adjusting session_authorization and role in parallel workers. The code intends to allow GUCs to be set within parallel workers via function SET clauses, but not otherwise. However, doing so fails for "session_authorization" and "role", because the assign hooks for those attempt to set the s

pgsql: Allow adjusting session_authorization and role in parallel worke

2024-08-10 Thread Tom Lane
Allow adjusting session_authorization and role in parallel workers. The code intends to allow GUCs to be set within parallel workers via function SET clauses, but not otherwise. However, doing so fails for "session_authorization" and "role", because the assign hooks for those attempt to set the s

pgsql: Allow adjusting session_authorization and role in parallel worke

2024-08-10 Thread Tom Lane
Allow adjusting session_authorization and role in parallel workers. The code intends to allow GUCs to be set within parallel workers via function SET clauses, but not otherwise. However, doing so fails for "session_authorization" and "role", because the assign hooks for those attempt to set the s

pgsql: Allow adjusting session_authorization and role in parallel worke

2024-08-10 Thread Tom Lane
Allow adjusting session_authorization and role in parallel workers. The code intends to allow GUCs to be set within parallel workers via function SET clauses, but not otherwise. However, doing so fails for "session_authorization" and "role", because the assign hooks for those attempt to set the s

pgsql: Allow adjusting session_authorization and role in parallel worke

2024-08-10 Thread Tom Lane
Allow adjusting session_authorization and role in parallel workers. The code intends to allow GUCs to be set within parallel workers via function SET clauses, but not otherwise. However, doing so fails for "session_authorization" and "role", because the assign hooks for those attempt to set the s

pgsql: Allow adjusting session_authorization and role in parallel worke

2024-08-10 Thread Tom Lane
Allow adjusting session_authorization and role in parallel workers. The code intends to allow GUCs to be set within parallel workers via function SET clauses, but not otherwise. However, doing so fails for "session_authorization" and "role", because the assign hooks for those attempt to set the s

pgsql: Allow adjusting session_authorization and role in parallel worke

2024-08-10 Thread Tom Lane
Allow adjusting session_authorization and role in parallel workers. The code intends to allow GUCs to be set within parallel workers via function SET clauses, but not otherwise. However, doing so fails for "session_authorization" and "role", because the assign hooks for those attempt to set the s

pgsql: Add tests for pg_wal_replay_wait() errors

2024-08-10 Thread Alexander Korotkov
Add tests for pg_wal_replay_wait() errors Improve test coverage for pg_wal_replay_wait() procedure by adding test cases when it errors out. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/0868d7ae70e57f4eeba43792db92ce2d9fe4340d Modified Files -- src/te

pgsql: Adjust pg_wal_replay_wait() procedure behavior on promoted stand

2024-08-10 Thread Alexander Korotkov
Adjust pg_wal_replay_wait() procedure behavior on promoted standby pg_wal_replay_wait() is intended to be called on standby. However, standby can be promoted to primary at any moment, even concurrently with the pg_wal_replay_wait() call. If recovery is not currently in progress that doesn't mean

pgsql: Improve header comment for WaitLSNSetLatches()

2024-08-10 Thread Alexander Korotkov
Improve header comment for WaitLSNSetLatches() Reflect the fact that we remove waiters from the heap, not just set their latches. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/3ac3ec580c6f4f991d32252814e4b04c0e903a41 Modified Files -- src/backend/comm

pgsql: Lower minimum maintenance_work_mem to 64kB

2024-08-10 Thread John Naylor
Lower minimum maintenance_work_mem to 64kB Since the introduction of TID store, vacuum uses far less memory in the common case than in versions 16 and earlier. Invoking multiple rounds of index vacuuming in turn requires a much larger table. It'd be a good idea anyway to cover this case in regress

pgsql: Lower minimum maintenance_work_mem to 64kB

2024-08-10 Thread John Naylor
Lower minimum maintenance_work_mem to 64kB Since the introduction of TID store, vacuum uses far less memory in the common case than in versions 16 and earlier. Invoking multiple rounds of index vacuuming in turn requires a much larger table. It'd be a good idea anyway to cover this case in regress