pgsql: Introduce helper SIMD functions for small byte arrays

Introduce helper SIMD functions for small byte arrays vector8_min - helper for emulating ">=" semantics vector8_highbit_mask - used to turn the result of a vector comparison into a bitmask Masahiko Sawada Reviewed by Nathan Bossart, with additional adjustments by me Discussion:

pgsql: Move some bitmap logic out of bitmapset.c

Move some bitmap logic out of bitmapset.c Move the logic for selecting appropriate pg_bitutils.h functions based on word size to bitmapset.h for wider visibility. Reviewed (in a previous version) by Tom Lane Discussion:

pgsql: Doc: Improve replication slot synchronization section.

Doc: Improve replication slot synchronization section. Author: Peter Smith Reviewed-by: Michael Paquier, Laurenz Albe Discussion: https://postgr.es/m/cahut+ps01fv9bjhj6njcfihu0w0gu1jcu0tko0rymhhx-hz...@mail.gmail.com Branch -- master Details ---

pgsql: Add recovery TAP test for race condition with slot invalidations

Add recovery TAP test for race condition with slot invalidations This commit adds a recovery test to provide coverage for the bug fixed in 818fefd8fd, using an injection point to wait just after the process of an active slot is killed. The trick is to give enough time for effective_xmin and

pgsql: Add --copy-file-range option to pg_upgrade.

Add --copy-file-range option to pg_upgrade. The copy_file_range() system call is available on at least Linux and FreeBSD, and asks the kernel to use efficient ways to copy ranges of a file. Options available to the kernel include sharing block ranges (similar to --clone mode), and pushing down

pgsql: Remove surplus trailing semicolon

Remove surplus trailing semicolon Author: Richard Guo Discussion: https://postgr.es/m/CAMbWs4-qjotfa7G=5peow4ldddx58mmtwddpdou3quse_bk...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/2bce0ad67f93af6d1889ec611a8f618245291e3f Modified Files

pgsql: Add a few recent commits to .git-blame-ignore-revs.

Add a few recent commits to .git-blame-ignore-revs. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/571530452fe0b15727b8b6730e64800a5e96a7b2 Modified Files -- .git-blame-ignore-revs | 12 1 file changed, 12 insertions(+)

pgsql: Run pgindent again on the same file.

Run pgindent again on the same file. Apparently, pgindent got confused by the double space. The first time I ran it, it moved the function name to the next line. The second time I ran it, it moved the function name back, but without the double space. Now the results appear stable. Branch --

pgsql: Run pgindent for commit ef4cfdce0e.

Run pgindent for commit ef4cfdce0e. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/b406af1806e9fc5c090e58282c7d98f22a4b397f Modified Files -- src/backend/utils/activity/backend_status.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-)

pgsql: docs: Update HOT update docs for 19d8e2308b

docs: Update HOT update docs for 19d8e2308b Commit 19d8e2308b changed when the HOT update optimization is possible but neglected to update the Heap-Only Tuples (HOT) documentation. This patch updates that documentation accordingly. Author: Elizabeth Christensen Backpatch-through: 16

pgsql: docs: Update HOT update docs for 19d8e2308b

docs: Update HOT update docs for 19d8e2308b Commit 19d8e2308b changed when the HOT update optimization is possible but neglected to update the Heap-Only Tuples (HOT) documentation. This patch updates that documentation accordingly. Author: Elizabeth Christensen Backpatch-through: 16

pgsql: Update sepgsql expected output.

Update sepgsql expected output. Fix for buildfarm member rhinoceros after commit 2af07e2f74. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c7ea3f42291bf5c74be8f957c775c5e7b3f78592 Modified Files -- contrib/sepgsql/expected/ddl.out | 37

pgsql: Fix references to renamed function in comments

Fix references to renamed function in comments I renamed the function in commit 024c521117, but missed these comments. Reported-by: Richard Guo Discussion: https://www.postgresql.org/message-id/cambws4-jr6qc7jrmkwz-zxqy_ayluz3phjgep4b91of321c...@mail.gmail.com Branch -- master Details

pgsql: Improve field order in RangeTblEntry

Improve field order in RangeTblEntry When perminfoindex was added, it was just added at the end of the block. It would make sense to keep it closer to more related fields. In passing, also add an inline comment, like the other fields have. (Other field reorderings and documentation improvements

pgsql: Fix misspelled assertions

Fix misspelled assertions Remove an extra & operator, per Tom Lane. My bugs, introduced with commit 53c2a97a9266. Discussion: https://postgr.es/m/3885480.1709590...@sss.pgh.pa.us Branch -- master Details ---

pgsql: Rework redundant code in subtrans.c

Rework redundant code in subtrans.c When this code was written the duplicity didn't matter, but with all the SLRU-bank stuff we just added, it has become excessive. Turn it into a simpler loop with no code duplication. Also add a test so that this code becomes covered. Discussion:

pgsql: Rename pg_constraint.conwithoutoverlaps to conperiod

Rename pg_constraint.conwithoutoverlaps to conperiod pg_constraint.conwithoutoverlaps was recently added to support primary keys and unique constraints with the WITHOUT OVERLAPS clause. An upcoming patch provides the foreign-key side of this functionality, but the syntax there is different and