Re: pgsql: Add vacuum_truncate configuration parameter.

2025-03-23 Thread David Rowley
On Sat, 22 Mar 2025 at 05:40, David G. Johnston wrote: > Not seeing much point in trying to get rid of the on/off switch. It just > won't make sense to choose a tunable value of zero to disable something, and > probably should be prohibited. Can you explain what does not make sense about it?

pgsql: Allow plugins to set a 64-bit plan identifier in PlannedStmt

2025-03-23 Thread Michael Paquier
Allow plugins to set a 64-bit plan identifier in PlannedStmt This field can be optionally set in a PlannedStmt through the planner hook, giving extensions the possibility to assign an identifier related to a computed plan. The backend is changed to report it in the backend entry of a process runn

pgsql: Fix rare assertion failure in standby, if primary is restarted

2025-03-23 Thread Heikki Linnakangas
Fix rare assertion failure in standby, if primary is restarted During hot standby, ExpireAllKnownAssignedTransactionIds() and ExpireOldKnownAssignedTransactionIds() functions mark old transactions as no-longer running, but they failed to update xactCompletionCount and latestCompletedXid. AFAICS it

pgsql: Fix rare assertion failure in standby, if primary is restarted

2025-03-23 Thread Heikki Linnakangas
Fix rare assertion failure in standby, if primary is restarted During hot standby, ExpireAllKnownAssignedTransactionIds() and ExpireOldKnownAssignedTransactionIds() functions mark old transactions as no-longer running, but they failed to update xactCompletionCount and latestCompletedXid. AFAICS it

pgsql: psql: Add tab completion for VACUUM and ANALYZE ... ONLY option.

2025-03-23 Thread Tom Lane
psql: Add tab completion for VACUUM and ANALYZE ... ONLY option. Improve psql's tab completion for VACUUM and ANALYZE by supporting the ONLY option introduced in 62ddf7ee9. In passing, simplify some of the VACUUM patterns by making use of MatchAnyN. Author: Umar Hayat Reviewed-by: Vignesh C Re

pgsql: Fix "make clean" for new TAP suite.

2025-03-23 Thread Noah Misch
Fix "make clean" for new TAP suite. Commit 28f04984f0c240b76e61f00cd247554fbc850056 missed this. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/f0446384ea7c4274894d7f5b215bfc2496ace85d Modified Files -- src/interfaces/ecpg/preproc/Makefile | 1 + 1 file