Re: pgsql: Make archiver process an auxiliary process.

2021-06-15 Thread Fujii Masao
On 2021/06/12 19:36, Thomas Munro wrote: On Mon, Mar 15, 2021 at 5:14 PM Fujii Masao wrote: Make archiver process an auxiliary process. This commit changes WAL archiver process so that it's treated as an auxiliary process and can use shared memory. This is an infrastructure patch required f

pgsql: Update another variant expected-result file.

2021-06-15 Thread Tom Lane
Update another variant expected-result file. This should have been updated in 533e9c6b0, but it was overlooked. Given the lack of complaints, I won't bother back-patching. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/d3c878499c9d639ff06e0664d06b8c731e30c2fc Modi

pgsql: Remove another orphan expected-result file.

2021-06-15 Thread Tom Lane
Remove another orphan expected-result file. aborted-keyrevoke_2.out was apparently needed when it was added (in commit 0ac5ad513) to handle the case of serializable transaction mode. However, the output in serializable mode actually matches the regular aborted-keyrevoke.out file, and AFAICT has do

pgsql: Further refinement of stuck_on_old_timeline recovery test

2021-06-15 Thread Andrew Dunstan
Further refinement of stuck_on_old_timeline recovery test TestLib::perl2host can take a file argument as well as a directory argument, so that code becomes substantially simpler. Also add comments on why we're using forward slashes, and why we're setting PERL_BADLANG=0. Discussion: https://postg

pgsql: Further refinement of stuck_on_old_timeline recovery test

2021-06-15 Thread Andrew Dunstan
Further refinement of stuck_on_old_timeline recovery test TestLib::perl2host can take a file argument as well as a directory argument, so that code becomes substantially simpler. Also add comments on why we're using forward slashes, and why we're setting PERL_BADLANG=0. Discussion: https://postg

pgsql: Further refinement of stuck_on_old_timeline recovery test

2021-06-15 Thread Andrew Dunstan
Further refinement of stuck_on_old_timeline recovery test TestLib::perl2host can take a file argument as well as a directory argument, so that code becomes substantially simpler. Also add comments on why we're using forward slashes, and why we're setting PERL_BADLANG=0. Discussion: https://postg

pgsql: Further refinement of stuck_on_old_timeline recovery test

2021-06-15 Thread Andrew Dunstan
Further refinement of stuck_on_old_timeline recovery test TestLib::perl2host can take a file argument as well as a directory argument, so that code becomes substantially simpler. Also add comments on why we're using forward slashes, and why we're setting PERL_BADLANG=0. Discussion: https://postg

pgsql: Further refinement of stuck_on_old_timeline recovery test

2021-06-15 Thread Andrew Dunstan
Further refinement of stuck_on_old_timeline recovery test TestLib::perl2host can take a file argument as well as a directory argument, so that code becomes substantially simpler. Also add comments on why we're using forward slashes, and why we're setting PERL_BADLANG=0. Discussion: https://postg

pgsql: Further refinement of stuck_on_old_timeline recovery test

2021-06-15 Thread Andrew Dunstan
Further refinement of stuck_on_old_timeline recovery test TestLib::perl2host can take a file argument as well as a directory argument, so that code becomes substantially simpler. Also add comments on why we're using forward slashes, and why we're setting PERL_BADLANG=0. Discussion: https://postg

pgsql: Revert 29854ee8d1 due to buildfarm failures

2021-06-15 Thread Alexander Korotkov
Revert 29854ee8d1 due to buildfarm failures Reported-by: Tom Lane Discussion: https://postgr.es/m/CAPpHfdvcnw3x7jdV3r52p4%3D5S4WUxBCzcQKB3JukQHoicv1LSQ%40mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/817bb0a7d1e02df4643d37304aed8574cf43f629 Modifi

pgsql: Remove unneeded field from VACUUM state.

2021-06-15 Thread Peter Geoghegan
Remove unneeded field from VACUUM state. Bugfix commit 5fc89376 effectively made the lock_waiter_detected field from vacuumlazy.c's global state struct into private state owned by lazy_truncate_heap(). Finish this off by replacing the struct field with a local variable. Branch -- master Det

pgsql: Add missing type name "multirange" in docs chapter title

2021-06-15 Thread Alexander Korotkov
Add missing type name "multirange" in docs chapter title Discussion: https://postgr.es/m/CAFj8pRDioOxiJgmgw9TqQqZ3CxnJC4P5B2Oospf2eMgAjJuewA%40mail.gmail.com Author: Pavel Stehule, Alexander Korotkov Reviewed-by: Justin Pryzby, Tom Lane Branch -- master Details --- https://git.postgresq

pgsql: Support for unnest(multirange) and cast multirange as an array o

2021-06-15 Thread Alexander Korotkov
Support for unnest(multirange) and cast multirange as an array of ranges It has been spotted that multiranges lack of ability to decompose them into individual ranges. Subscription and proper expanded object representation require substantial work, and it's too late for v14. This commit provides