pgsql: Fix EXPLAIN of SEARCH BREADTH FIRST queries some more.

2021-10-11 Thread Tom Lane
Fix EXPLAIN of SEARCH BREADTH FIRST queries some more. Commit 3f50b8263 had an oversight: formerly, to deparse expressions attached to a plan node, it was only necessary to update the deparse_namespace ancestors list alongside calling set_deparse_plan. Now it's necessary to update the ancestors li

pgsql: Fix EXPLAIN of SEARCH BREADTH FIRST queries some more.

2021-10-11 Thread Tom Lane
Fix EXPLAIN of SEARCH BREADTH FIRST queries some more. Commit 3f50b8263 had an oversight: formerly, to deparse expressions attached to a plan node, it was only necessary to update the deparse_namespace ancestors list alongside calling set_deparse_plan. Now it's necessary to update the ancestors li

pgsql: Make configure check for minimum required version of IPC::Run.

2021-10-11 Thread Tom Lane
Make configure check for minimum required version of IPC::Run. Per the discussion around 3eb1f4d09, let's have configure verify that the available IPC::Run version is at least 0.79, the agreed-on minimum. It seems unlikely that this could bite anybody anymore, but it's useful as documentation. (B

pgsql: amcheck: Skip unlogged relations in Hot Standby.

2021-10-11 Thread Peter Geoghegan
amcheck: Skip unlogged relations in Hot Standby. Have verify_heapam.c treat unlogged relations as if they were simply empty when in Hot Standby mode. This brings it in line with verify_nbtree.c, which has handled unlogged relations in the same way since bugfix commit 6754fe65a4. This was an over

pgsql: amcheck: Skip unlogged relations in Hot Standby.

2021-10-11 Thread Peter Geoghegan
amcheck: Skip unlogged relations in Hot Standby. Have verify_heapam.c treat unlogged relations as if they were simply empty when in Hot Standby mode. This brings it in line with verify_nbtree.c, which has handled unlogged relations in the same way since bugfix commit 6754fe65a4. This was an over

pgsql: Make autovacuum launcher more responsive to pg_log_backend_memor

2021-10-11 Thread Fujii Masao
Make autovacuum launcher more responsive to pg_log_backend_memory_contexts(). Previously when pg_log_backend_memory_contexts() sent the request to the autovacuum launcher, it could take more than several seconds to log its memory contexts. Because the function (HandleAutoVacLauncherInterrupts) to

pgsql: Make autovacuum launcher more responsive to pg_log_backend_memor

2021-10-11 Thread Fujii Masao
Make autovacuum launcher more responsive to pg_log_backend_memory_contexts(). Previously when pg_log_backend_memory_contexts() sent the request to the autovacuum launcher, it could take more than several seconds to log its memory contexts. Because the function (HandleAutoVacLauncherInterrupts) to

pgsql: Add more $Test::Builder::Level in the TAP tests

2021-10-11 Thread Michael Paquier
Add more $Test::Builder::Level in the TAP tests Incrementing the level of the call stack reported is useful for debugging purposes as it allows to control which part of the test is exactly failing, especially if a test is structured with subroutines that call routines from Test::More. This adds m

pgsql: Add more $Test::Builder::Level in the TAP tests

2021-10-11 Thread Michael Paquier
Add more $Test::Builder::Level in the TAP tests Incrementing the level of the call stack reported is useful for debugging purposes as it allows to control which part of the test is exactly failing, especially if a test is structured with subroutines that call routines from Test::More. This adds m

pgsql: Add more $Test::Builder::Level in the TAP tests

2021-10-11 Thread Michael Paquier
Add more $Test::Builder::Level in the TAP tests Incrementing the level of the call stack reported is useful for debugging purposes as it allows to control which part of the test is exactly failing, especially if a test is structured with subroutines that call routines from Test::More. This adds m

pgsql: Add more $Test::Builder::Level in the TAP tests

2021-10-11 Thread Michael Paquier
Add more $Test::Builder::Level in the TAP tests Incrementing the level of the call stack reported is useful for debugging purposes as it allows to control which part of the test is exactly failing, especially if a test is structured with subroutines that call routines from Test::More. This adds m