PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Recent Activity

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.

Activity Earlier In The Year

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.

doc: first draft of the PG 18 release notes
Bruce Momjian

Bump the minimum supported Python version to 3.6.8
Jacob Champion: Python 3.2 is no longer tested by the buildfarm, and there are only a handful of buildfarm animals running versions older than 3.6, which itself went end-of-life in 2021.

Add maintenance_io_concurrency flag to some read stream users
Melanie Plageman: Index vacuuming and [auto]prewarm AIO concurrency should be governed by maintenance_io_concurrency.

Eliminate divide in new fast-path locking code
David Rowley: c4d5cb71d2 adjusted the fast-path locking code to allow some configuration of the number of fast-path locking slots via the max_locks_per_transaction GUC.

Change the names generated for child foreign key constraints
Tom Lane: When a foreign key constraint is placed on a partitioned table, we actually make two pg_constraint entries associated with that table.

PostgreSQL Release Tags

Support SSL_R_VERSION_TOO_LOW when using LibreSSL
Daniel Gustafsson: The SSL_R_VERSION_TOO_LOW error reason is supported in LibreSSL since LibreSSL 3.6.3, shipped in OpenBSD 7.2.

Log OpenSSL version in ./configure output
Michael Paquier: This information is useful to know when scanning buildfarm results, and it is already displayed in Meson.

meson: Improve PG_VERSION_STR generation
Andres Freund: Previously the host operating system and 32/64 bit were not included and the build machine's cpu was used, which is potentially wrong for cross builds.

Fix ALTER COLLATION "default" REFRESH VERSION.
Jeff Davis: Issue a helpful error message rather than an internal error. Discussion:

Require version 0.98 of Test::More for TAP tests
Andrew Dunstan: This means that the subtest feature will be available for use. We expect that this change will make prairiedog go red until it is updated, but other buildfarm animals should be fine. Discussion:

doc: Fix link reference for PGSSLMAXPROTOCOLVERSION
Michael Paquier: The link was pointing to the minimum protocol version.

nbtree: BTREE_[MIN|NOVAC]_VERSION comment tweaks
Peter Geoghegan: Author: Peter Geoghegan

Automate the maintenance of SO_MINOR_VERSION for our shared libraries
Tom Lane: Up to now we've manually adjusted these numbers in several different Makefiles at the start of each development cycle.

Advance PG_CONTROL_VERSION.
Tom Lane: This should have been done in commit 73c986adde5d73a5 which added several new fields to pg_control, and again in commit 5028f22f6eb05798 which changed the CRC algorithm, but it wasn't.

Tab complete CREATE EXTENSION .. VERSION.
Robert Haas: Jeff Janes

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.

Support falling back to non-preferred readline implementation with meson
Heikki Linnakangas: To build with -Dreadline=enabled one can use either readline or libedit.

pg_verifybackup: Verify tar-format backups
Robert Haas: This also works for compressed tar-format backups.

Wait for WAL summarization to catch up before creating .partial file
Robert Haas: When a standby is promoted, CleanupAfterArchiveRecovery() may decide to rename the final WAL file from the old timeline by adding ".partial" to the name.

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.

Log the conflicts while applying changes in logical replication
Amit Kapila: This patch provides the additional logging information in the following conflict scenarios while applying changes: insert_exists: Inserting a row that violates a NOT DEFERRABLE unique constraint.

Speed up Hash Join by making ExprStates support hashing
David Rowley: Here we add ExprState support for obtaining a 32-bit hash value from a list of expressions.

injection_points: Add some fixed-numbered statistics
Michael Paquier: Like 75534436a477, this acts mainly as a template to show what can be achieved with fixed-numbered stats (like WAL, bgwriter, etc.) with the pluggable cumulative statistics APIs introduced in 7949d9594582. Fixed-numbered stats are defined in their own file, named injection_stats_fixed.c, separated entirely from the variable-numbered case in injection_stats.c.

pg_stat_statements: Add columns to track parallel worker activity
Michael Paquier: The view pg_stat_statements gains two columns:- parallel_workers_to_launch, the number of parallel workers planned to be launched.- parallel_workers_launched, the number of parallel workers actually launched. The ratio of both columns offers hints that parallel workers are lacking on a per-statement basis, requiring some tuning, in coordination with "calls", the number of times a query is executed. As of now, these numbers are tracked within Gather and GatherMerge nodes.

PostgreSQL

Recent Activity

Activity Earlier In The Year

PostgreSQL Release Tags

Most Popular This Year