Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Yesterday's Activity

file_fdw: Add REJECT_LIMIT option to file_fdw
Fujii Masao: Commit 4ac2a9bece introduced the REJECT_LIMIT option for the COPY command.

Other Activity This Week

Avoid deleting critical WAL segments during pg_rewind
Álvaro Herrera: Previously, in unlucky cases, it was possible for pg_rewind to remove certain WAL segments from the rewound demoted primary.

Fix race conditions with drop of reused pgstats entries
Michael Paquier: This fixes a set of race conditions with cumulative statistics where a shared stats entry could be dropped while it should still be valid in the event when it is reused: an entry may refer to a different object but requires the same hash key.

Recent Activity

file_fdw: Add REJECT_LIMIT option to file_fdw
Fujii Masao: Commit 4ac2a9bece introduced the REJECT_LIMIT option for the COPY command.

Avoid deleting critical WAL segments during pg_rewind
Álvaro Herrera: Previously, in unlucky cases, it was possible for pg_rewind to remove certain WAL segments from the rewound demoted primary.

Fix race conditions with drop of reused pgstats entries
Michael Paquier: This fixes a set of race conditions with cumulative statistics where a shared stats entry could be dropped while it should still be valid in the event when it is reused: an entry may refer to a different object but requires the same hash key.

Assign a child slot to every postmaster child process
Heikki Linnakangas: Previously, only backends, autovacuum workers, and background workers had an entry in the PMChildFlags array.

Kill dead-end children when there's nothing else left
Heikki Linnakangas: Previously, the postmaster would never try to kill dead-end child processes, even if there were no other processes left.

Add nbtree amgettuple return item function
Peter Geoghegan: This makes it easier to add precondition assertions.

doc: Add PERIOD to ALTER TABLE reference docs
Peter Eisentraut: Commit 89f908a6d0a documented foreign keys with PERIOD in the CREATE TABLE docs, but not in ALTER TABLE.

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.

Fix improper interactions between session_authorization and role
Tom Lane: The SQL spec mandates that SET SESSION AUTHORIZATION implies SET ROLE NONE.

Ensure cached plans are correctly marked as dependent on role
Nathan Bossart: If a CTE, subquery, sublink, security invoker view, or coercion projection references a table with row-level security policies, we neglected to mark the plan as potentially dependent on which role is executing it.

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 In The Past Month

Monkey-patch LLVM code to fix ARM relocation bug
Thomas Munro: Supply a new memory manager for RuntimeDyld, to avoid crashes in generated code caused by memory placement that can overflow a 32 bit data type.

Raise the minimum supported OpenSSL version to 1.1.1
Daniel Gustafsson: Commit a70e01d4306fdbcd retired support for OpenSSL 1.0.2 in order to get rid of the need for manual initialization of the library.

Add PG_TEST_EXTRA configure option to the Make builds
Heikki Linnakangas: The Meson builds have PG_TEST_EXTRA as a configure-time variable, which was not available in the Make builds.

doc: Remove event trigger firing matrix
Peter Eisentraut: This is difficult to maintain accurately, and it was probably already somewhat incorrect, especially in the sql_drop and table_rewrite categories.

Add a Git .mailmap file
Daniel Gustafsson: This adds a Git .mailmap to unify spellings of committer names.

Support configuring TLSv1.3 cipher suites
Daniel Gustafsson: The ssl_ciphers GUC can only set cipher suites for TLSv1.2, and lower, connections.

Support configuring multiple ECDH curves
Daniel Gustafsson: The ssl_ecdh_curve GUC only accepts a single value, but the TLS handshake can list multiple curves in the groups extension (the extension has been renamed to contain more than elliptic curves).

For inplace update, send nontransactional invalidations
Noah Misch: The inplace update survives ROLLBACK.

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.

Doc: Add a caution in alter publication
Amit Kapila: Clarify that altering the 'publish_via_partition_root' option can lead to data loss or duplication when a partition root table is specified as the replication target.

Legal Disclaimer & Disclosure | Contact Us
Copyright © 2010 - 2024 by Phoronix Media. All rights reserved.
All trademarks and copyrights used are properties of their respective owners.
Powered by the Phoronix Content Management System (PHXCMS-8).