PostgreSQL
PostgeSQL is a leading open-source SQL database server.
www.postgresql.org
Activity Earlier In The Year
- Doc: Make logical replication examples executable in bulk
Amit Kapila: To improve the usability of logical replication examples, we need to enable bulk copy-pasting of DML/DDL series.
Currently, output command tags and prompts disrupt this workflow. - pg_dump: Adjust reltuples from 0 to -1 for dumps of older versions
Nathan Bossart: Before v14, a reltuples value of 0 was ambiguous: it could either mean the relation is empty, or it could mean that it hadn't yet been vacuumed or analyzed. - Doc: add pre-branch task to run src/tools/copyright.pl
Tom Lane: It's common for some files with last year's copyright date to sneak into the tree between early January (when we normally run copyright.pl) and feature freeze. - Make our usage of memset_s() conform strictly to the C11 standard
Tom Lane: Per the letter of the C11 standard, one must #define __STDC_WANT_LIB_EXT1__ as 1 before including <string.h> in order to have access to memset_s(). - Add explicit initialization for all PlannerGlobal fields
Richard Guo: When creating a new PlannerGlobal node in standard_planner(), most fields are explicitly initialized, but a few are not. - Add tab-complete for ALTER DOMAIN ADD [CONSTRAINT]
Álvaro Herrera: We can add tab-completion with "CHECK (" and "NOT NULL" after ALTER DOMAIN ADD [CONSTRAINT]. - Add support for runtime arguments in injection points
Michael Paquier: The macros INJECTION_POINT() and INJECTION_POINT_CACHED() are extended with an optional argument that can be passed down to the callback attached when an injection point is run, giving to callbacks the possibility to manipulate a stack state given by the caller. - Suppress unnecessary explicit sorting for EPQ mergejoin path
Richard Guo: When building a ForeignPath for a joinrel, if there's a possibility that EvalPlanQual will be executed, we must identify a suitable path for EPQ checks. - doc: Add link to table
Peter Eisentraut: Formal tables should generally have an xref in the text that points to them. - doc PG 18 relnotes: add GROUP BY column elimination item
Bruce Momjian: With a nod to PG 9.
Most Popular This Year
- extension_control_path
Peter Eisentraut: The new GUC specifies a path to look for extension control files. - Add two attributes to pg_stat_database for parallel workers activity
Michael Paquier: Two attributes are added to pg_stat_database:
- parallel_workers_to_launch, counting the total number of parallel workers that were planned to be launched.
- parallel_workers_launched, counting the total number of parallel workers actually launched.
The ratio of both fields can provide hints that there are not enough slots available when launching parallel workers, also useful when pg_stat_statements is not deployed on an instance (i.e. - pg_rewind: Add dbname to primary_conninfo when using --write-recovery-conf
Masahiko Sawada: This commit enhances pg_rewind's --write-recovery-conf option to include the dbname in the generated primary_conninfo value when specified in the --source-server option. - Add pg_dump --with-{schema|data|statistics} options
Jeff Davis: By adding the positive variants of options, in addition to the negative variants that already exist, users can be explicit about what pg_dump should produce. - Small fixes for Add ALTER TABLE ... ALTER CONSTRAINT ... SET [NO] INHERIT
Peter Eisentraut: Small fixes for commit f4e53e10b6c: Add missing calls to InvokeObjectPostAlterHook() and also CacheInvalidateRelcache(). - pg_verifybackup: Verify tar-format backups
Robert Haas: This also works for compressed tar-format backups. - Fix waits of REINDEX CONCURRENTLY for indexes with predicates or expressions
Michael Paquier: As introduced by f9900df5f94, a REINDEX CONCURRENTLY job done for an index with predicates or expressions would set PROC_IN_SAFE_IC in its MyProc->statusFlags, causing it to be ignored by other concurrent operations.
Such concurrent index rebuilds should never be ignored, as a predicate or an expression could call a user-defined function that accesses a different table than the table where the index is rebuilt.
A test that uses injection points is added, backpatched down to 17. - Remove test-case workarounds for ancient libedit versions
Tom Lane: This reverts some hacks added in d33a81203 and cd69ec66c. - doc: Add WITHOUT OVERLAPS to ALTER TABLE reference docs
Peter Eisentraut: Commit fc0438b4e80 documented WITHOUT OVERLAPS in the CREATE TABLE docs, but not in ALTER TABLE. - Add WAL usage reporting to ANALYZE VERBOSE output
Masahiko Sawada: This change adds WAL usage reporting to the output of ANALYZE VERBOSE and autoanalyze reports.