pgsql: pg_stat_statements: Add counters for generic and custom plans

2025-07-30 Thread Michael Paquier
pg_stat_statements: Add counters for generic and custom plans This patch adds two new counters to pg_stat_statements: - generic_plan_calls - custom_plan_calls These counters track how many times a prepared statement was executed using a generic or custom plan, respectively, providing a global equ

pgsql: Rename CachedPlanType to PlannedStmtOrigin for PlannedStmt

2025-07-30 Thread Michael Paquier
Rename CachedPlanType to PlannedStmtOrigin for PlannedStmt Commit 719dcf3c42 introduced a field called CachedPlanType in PlannedStmt to allow extensions to determine whether a cached plan is generic or custom. After discussion, the concepts that we want to track are a bit wider than initially ant

pgsql: doc: Adjust documentation for vacuumdb --missing-stats-only.

2025-07-30 Thread Nathan Bossart
doc: Adjust documentation for vacuumdb --missing-stats-only. The sentence in question gave readers the impression that vacuumdb removes statistics for a period of time while analyzing, but it's actually meant to convey that --analyze-in-stages temporarily replaces existing statistics with ones gen

pgsql: doc: Adjust documentation for vacuumdb --missing-stats-only.

2025-07-30 Thread Nathan Bossart
doc: Adjust documentation for vacuumdb --missing-stats-only. The sentence in question gave readers the impression that vacuumdb removes statistics for a period of time while analyzing, but it's actually meant to convey that --analyze-in-stages temporarily replaces existing statistics with ones gen

pgsql: Teach pg_upgrade to handle in-place tablespaces.

2025-07-30 Thread Nathan Bossart
Teach pg_upgrade to handle in-place tablespaces. Presently, pg_upgrade assumes that all non-default tablespaces don't move to different directories during upgrade. Unfortunately, this isn't true for in-place tablespaces, which move to the new cluster's pg_tblspc directory. This commit teaches pg

pgsql: Remove release note item for Non text modes for pg_dumpall

2025-07-30 Thread Andrew Dunstan
Remove release note item for Non text modes for pg_dumpall The feature has been reverted. Branch -- REL_18_STABLE Details --- https://git.postgresql.org/pg/commitdiff/3a954813a0fb0fd205f8846a6d3d19a0da62b974 Modified Files -- doc/src/sgml/release-18.sgml | 20 ---

pgsql: Revert Non text modes for pg_dumpall, and pg_restore support

2025-07-30 Thread Andrew Dunstan
Revert Non text modes for pg_dumpall, and pg_restore support Recent discussions of the mechanisms used to manage global data have raised concerns about their robustness and security. Rather than try to deal with those concerns at a very late stage of the release cycle, the conclusion is to revert

pgsql: Revert Non text modes for pg_dumpall, and pg_restore support

2025-07-30 Thread Andrew Dunstan
Revert Non text modes for pg_dumpall, and pg_restore support Recent discussions of the mechanisms used to manage global data have raised concerns about their robustness and security. Rather than try to deal with those concerns at a very late stage of the release cycle, the conclusion is to revert

pgsql: Fix whitespace

2025-07-30 Thread Peter Eisentraut
Fix whitespace Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/00c977177956c4b4d12f8c6518d4269b086deca8 Modified Files -- doc/src/sgml/pageinspect.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)