pgsql: Fix the test 005_char_signedness.

2025-03-17 Thread Masahiko Sawada
Fix the test 005_char_signedness. pg_upgrade test 005_char_signedness was leaving files like delete_old_cluster.sh in the source directory for VPATH and meson builds. The fix is to change the directory to tmp_check before running the test. Reported-by: Robert Haas Reviewed-by: Robert Haas Discu

pgsql: psql: Add \sendpipeline to send query buffers while in a pipelin

2025-03-17 Thread Michael Paquier
psql: Add \sendpipeline to send query buffers while in a pipeline In the initial pipeline support for psql added in 41625ab8ea3d, \g was used as the way to push extended query into an ongoing pipeline. \gx was blocked. These two meta-commands have format-related options that can be applied when

pgsql: aio: Add core asynchronous I/O infrastructure

2025-03-17 Thread Andres Freund
aio: Add core asynchronous I/O infrastructure The main motivations to use AIO in PostgreSQL are: a) Reduce the time spent waiting for IO by issuing IO sufficiently early. In a few places we have approximated this using posix_fadvise() based prefetching, but that is fairly limited (no compl

pgsql: aio: Basic subsystem initialization

2025-03-17 Thread Andres Freund
aio: Basic subsystem initialization This commit just does the minimal wiring up of the AIO subsystem, added in the next commit, to the rest of the system. The next commit contains more details about motivation and architecture. This commit is kept separate to make it easier to review, separating

pgsql: Add commit 203c1b4cc4 to .git-blame-ignore-revs.

2025-03-17 Thread Nathan Bossart
Add commit 203c1b4cc4 to .git-blame-ignore-revs. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/65db3963ae7154b8f01e4d73dc6b1ffd81c70e1e Modified Files -- .git-blame-ignore-revs | 3 +++ 1 file changed, 3 insertions(+)

pgsql: Fix indentation.

2025-03-17 Thread Robert Haas
Fix indentation. Commit 99aeb84703177308c1541e2d11c09fdc59acb724 wasn't fully reindented prior to commit. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/203c1b4cc49455364b6bcab8034900d1c016b9cd Modified Files -- src/bin/pg_combinebackup/copy_file.c | 5

pgsql: pg_upgrade: Remove some dead code.

2025-03-17 Thread Nathan Bossart
pg_upgrade: Remove some dead code. Since commit e469f0aaf3, tablespace_suffix can't be empty. Reviewed-by: Tom Lane Discussion: https://postgr.es/m/Z9hc3mkYFKR56Xof%40nathan Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/7e05df430be36ad34d9c797b21f56a4b9c64bbc8

pgsql: tests: Expand temp table tests to some pin related matters

2025-03-17 Thread Andres Freund
tests: Expand temp table tests to some pin related matters Added tests: - recovery from running out of unpinned local buffers - that we don't run out of unpinned buffers due to read stream (only recently fixed, in 92fc6856cb4) - temp tables can't be dropped while in use by cursors Discussion: w

pgsql: pg_combinebackup: Add -k, --link option.

2025-03-17 Thread Robert Haas
pg_combinebackup: Add -k, --link option. This is similar to pg_upgrade's --link option, except that here we won't typically be able to use it for every input file: sometimes we will need to reconstruct a complete backup from blocks stored in different files. However, when a whole file does need to

pgsql: Unify wording of user-facing "row security" messages.

2025-03-17 Thread Tom Lane
Unify wording of user-facing "row security" messages. Row-level security is mostly referred to as "row security" in user-facing messages. Commit cd3c45125 introduced one inconsistent use of "row level security"; make that one match the rest. Author: Kyotaro Horiguchi Discussion: https://postgr