pgsql: Avoid BufferGetLSNAtomic() calls during nbtree scans.

2025-06-06 Thread Peter Geoghegan
Avoid BufferGetLSNAtomic() calls during nbtree scans. Delay calling BufferGetLSNAtomic() until we finish reading a page that actually contains items that btgettuple will return to the executor. This reduces the number of calls during plain index scans (we'll only call BufferGetLSNAtomic() when _bt

pgsql: pg_prewarm: Allow autoprewarm to use more than 1GB to dump block

2025-06-06 Thread Robert Haas
pg_prewarm: Allow autoprewarm to use more than 1GB to dump blocks. Reported-by: Daria Shanina Author: Daria Shanina Author: Robert Haas Backpatch-through: 13 Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/d59ff3be24a336ab080c66fa6ceafbf52e7be1c1 Modified

pgsql: pg_prewarm: Allow autoprewarm to use more than 1GB to dump block

2025-06-06 Thread Robert Haas
pg_prewarm: Allow autoprewarm to use more than 1GB to dump blocks. Reported-by: Daria Shanina Author: Daria Shanina Author: Robert Haas Backpatch-through: 13 Branch -- REL_17_STABLE Details --- https://git.postgresql.org/pg/commitdiff/e4b8f925a929fd57570097483a0fcf82dfc141da Modified

pgsql: pg_prewarm: Allow autoprewarm to use more than 1GB to dump block

2025-06-06 Thread Robert Haas
pg_prewarm: Allow autoprewarm to use more than 1GB to dump blocks. Reported-by: Daria Shanina Author: Daria Shanina Author: Robert Haas Backpatch-through: 13 Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/169429264d0638b18e01926977b910ab70457f14 Modified

pgsql: pg_prewarm: Allow autoprewarm to use more than 1GB to dump block

2025-06-06 Thread Robert Haas
pg_prewarm: Allow autoprewarm to use more than 1GB to dump blocks. Reported-by: Daria Shanina Author: Daria Shanina Author: Robert Haas Backpatch-through: 13 Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a4b9707c417666841733fe4f5bec9b18e184028e Modified

pgsql: pg_prewarm: Allow autoprewarm to use more than 1GB to dump block

2025-06-06 Thread Robert Haas
pg_prewarm: Allow autoprewarm to use more than 1GB to dump blocks. Reported-by: Daria Shanina Author: Daria Shanina Author: Robert Haas Backpatch-through: 13 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/4adbaa36ca8b0042ce24be187542e846ad3a7e51 Modified

pgsql: pg_prewarm: Allow autoprewarm to use more than 1GB to dump block

2025-06-06 Thread Robert Haas
pg_prewarm: Allow autoprewarm to use more than 1GB to dump blocks. Reported-by: Daria Shanina Author: Daria Shanina Author: Robert Haas Backpatch-through: 13 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/016e407f4ba10b230f5094c9ba36a1df3d34fb22 Modified Files

pgsql: Use NULL instead of 0 for pointer arguments.

2025-06-06 Thread Nathan Bossart
Use NULL instead of 0 for pointer arguments. Commit 5fe08c006c fixed this for calls to dshash_create(). This commit fixes calls to dshash_attach() and dsa_create_in_place(). Reviewed-by: Masahiko Sawada Reviewed-by: Michael Paquier Discussion: https://postgr.es/m/aECi_gSD9JnVWQ8T%40nathan Bra

pgsql: Fixed signed/unsigned mismatch in test_dsm_registry.

2025-06-06 Thread Nathan Bossart
Fixed signed/unsigned mismatch in test_dsm_registry. Oversight in commit 8b2bcf3f28. Reviewed-by: Masahiko Sawada Discussion: https://postgr.es/m/aECi_gSD9JnVWQ8T%40nathan Backpatch-through: 17 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/304862973e9a77c31cbf05

pgsql: Fixed signed/unsigned mismatch in test_dsm_registry.

2025-06-06 Thread Nathan Bossart
Fixed signed/unsigned mismatch in test_dsm_registry. Oversight in commit 8b2bcf3f28. Reviewed-by: Masahiko Sawada Discussion: https://postgr.es/m/aECi_gSD9JnVWQ8T%40nathan Backpatch-through: 17 Branch -- REL_17_STABLE Details --- https://git.postgresql.org/pg/commitdiff/65145d0955c494d

pgsql: Improve CREATE DATABASE error message for invalid libc locale.

2025-06-06 Thread Jeff Davis
Improve CREATE DATABASE error message for invalid libc locale. Discussion: https://postgr.es/m/73959a14-267b-49c1-8293-291b17568...@manitou-mail.org Reviewed-by: Daniel Verite Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/5b40feab594c3019fd6b09e46f97f5b367050cf9