pgsql: Re-enable autoruns for for cmd.exe on Windows

2024-07-07 Thread Michael Paquier
Re-enable autoruns for for cmd.exe on Windows This acts as a revert of b83747a8a65b and 9886744a361b. As pointed out by Noah, HEAD and REL_17_STABLE are in a weird state where the code paths adding /D would limit the spawn of child processes, but we still have code paths where the spawn of more t

pgsql: Re-enable autoruns for cmd.exe on Windows

2024-07-07 Thread Michael Paquier
Re-enable autoruns for cmd.exe on Windows This acts as a revert of b83747a8a65b and 9886744a361b. As pointed out by Noah, HEAD and REL_17_STABLE are in a weird state where the code paths adding /D would limit the spawn of child processes, but we still have code paths where the spawn of more than

pgsql: Fix right-anti-joins when the inner relation is proven unique

2024-07-07 Thread Richard Guo
Fix right-anti-joins when the inner relation is proven unique For an inner_unique join, we always assume that the executor will stop scanning for matches after the first match. Therefore, for a mergejoin that is inner_unique and whose mergeclauses are sufficient to identify a match, we set the sk

pgsql: Fix right-anti-joins when the inner relation is proven unique

2024-07-07 Thread Richard Guo
Fix right-anti-joins when the inner relation is proven unique For an inner_unique join, we always assume that the executor will stop scanning for matches after the first match. Therefore, for a mergejoin that is inner_unique and whose mergeclauses are sufficient to identify a match, we set the sk

pgsql: Fix right-anti-joins when the inner relation is proven unique

2024-07-07 Thread Richard Guo
Fix right-anti-joins when the inner relation is proven unique For an inner_unique join, we always assume that the executor will stop scanning for matches after the first match. Therefore, for a mergejoin that is inner_unique and whose mergeclauses are sufficient to identify a match, we set the sk

pgsql: Remove an extra period in code comment

2024-07-07 Thread Richard Guo
Remove an extra period in code comment Author: Junwang Zhao Discussion: https://postgr.es/m/CAEG8a3L9GgfKc+XT+NMHPY7atAOVYqjUqKEFQKhcPHFYRW=p...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/d7db04dfdae361479e77054670ee9d806c6a6420 Modified Files

pgsql: Widen lossy and exact page counters for Bitmap Heap Scan

2024-07-07 Thread David Rowley
Widen lossy and exact page counters for Bitmap Heap Scan Both of these counters were using the "long" data type. On MSVC that's a 32-bit type. On modern hardware, I was able to demonstrate that we can wrap those counters with a query that only takes 15 minutes to run. This issue may manifest it

pgsql: Renumber pg_get_acl() in pg_proc.dat

2024-07-07 Thread Michael Paquier
Renumber pg_get_acl() in pg_proc.dat a6417078c414 has introduced as project policy that new features committed during the development cycle should use new OIDs in the [8000,] range. 4564f1cebd43 did not respect that rule, so let's renumber pg_get_acl() to use an OID in the correct range. Bum