pgsql: heapam: Move logic to handle HEAP_MOVED into a helper function

2025-12-19 Thread Andres Freund
heapam: Move logic to handle HEAP_MOVED into a helper function Before we dealt with this in 6 near identical and one very similar copy. The helper function errors out when encountering a HEAP_MOVED_IN/HEAP_MOVED_OUT tuple with xvac considered current or in-progress. It'd be preferrable to do that

pgsql: bufmgr: Optimize & harmonize LockBufHdr(), LWLockWaitListLock()

2025-12-19 Thread Andres Freund
bufmgr: Optimize & harmonize LockBufHdr(), LWLockWaitListLock() The main optimization is for LockBufHdr() to delay initializing SpinDelayStatus, similar to what LWLockWaitListLock already did. The initialization is sufficiently expensive & buffer header lock acquisitions are sufficiently frequent,

pgsql: Update pg_hba.conf example to reflect MD5 deprecation

2025-12-19 Thread John Naylor
Update pg_hba.conf example to reflect MD5 deprecation In the wake of commit db6a4a985, remove most use of 'md5' from the example configuration file. The only remainder is an example exception for a client that doesn't support SCRAM. Author: Mikael Gustavsson Reviewed-by: Peter Eisentraut Review

pgsql: Update pg_hba.conf example to reflect MD5 deprecation

2025-12-19 Thread John Naylor
Update pg_hba.conf example to reflect MD5 deprecation In the wake of commit db6a4a985, remove most use of 'md5' from the example configuration file. The only remainder is an example exception for a client that doesn't support SCRAM. Author: Mikael Gustavsson Reviewed-by: Peter Eisentraut Review

pgsql: Use proper type for RestoreTransactionSnapshot's PGPROC arg

2025-12-19 Thread Heikki Linnakangas
Use proper type for RestoreTransactionSnapshot's PGPROC arg Reviewed-by: Chao Li Discussion: https://www.postgresql.org/message-id/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/47a9f61fcafcf26bd3d68740ca05ba69ac729d93

pgsql: doc: clarify when physical/logical replication is used

2025-12-19 Thread Bruce Momjian
doc: clarify when physical/logical replication is used The imprecision caused some text to be only partially accurate. Reported-by: Paul A Jungwirth Author: Robert Treat Discussion: https://postgr.es/m/CA%2BrenyULt3VBS1cRFKUfT2%3D5dr61xBOZdAZ-CqX3XLGXqY-aTQ%40mail.gmail.com Branch -- mas