PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Today's Activity

pg_overexplain: Additional EXPLAIN options for debugging
Robert Haas: There's a fair amount of information in the Plan and PlanState trees that isn't printed by any existing EXPLAIN option.

Use PG_MODULE_MAGIC_EXT in our installable shared libraries
Tom Lane: It seems potentially useful to label our shared libraries with version information, now that a facility exists for retrieving that.

dblink: SCRAM authentication pass-through
Peter Eisentraut: This enables SCRAM authentication for dblink (using dblink_fdw) when connecting to a foreign server without having to store a plain-text password on user mapping options This uses the same approach as it was implemented for postgres_fdw in commit 761c79508e7.

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.

Fix order of -I switches for building pg_regress.o
Tom Lane: We need the -I switch for libpq_srcdir to come before any -I switches injected by configure.

Yesterday's Activity

pg_upgrade: Add --swap for faster file transfer
Nathan Bossart: This new option instructs pg_upgrade to move the data directories from the old cluster to the new cluster and then to replace the catalog files with those generated for the new cluster.

Stats: use schemaname/relname instead of regclass
Jeff Davis: For import and export, use schemaname/relname rather than regclass.

psql: Make default \watch interval configurable
Daniel Gustafsson: The default interval for \watch to wait between executing queries, when executed without a specified interval, was hardcoded to two seconds.

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().

Generalize index support in network support function
Peter Eisentraut: The network (inet) support functions currently only supported a hardcoded btree operator family.

Other Activity This Week

psql: Add tab completion for VACUUM and ANALYZE ... ONLY option
Tom Lane: Improve psql's tab completion for VACUUM and ANALYZE by supporting the ONLY option introduced in 62ddf7ee9.

plpgsql: make WHEN OTHERS distinct from WHEN SQLSTATE '00000'.
Tom Lane: The catchall exception condition OTHERS was represented as sqlerrstate == 0, which was a poor choice because that comes out the same as SQLSTATE '00000'.

Improve nbtree array primitive scan scheduling
Peter Geoghegan: Add a new scheduling heuristic: don't end the ongoing primitive index scan immediately (at the point where _bt_advance_array_keys notices that the next set of matching tuples must be on a later page) if the primscan already managed to step right/left from its first leaf page.

Add GUC option to control maximum active replication origins
Masahiko Sawada: This commit introduces a new GUC option max_active_replication_origins to control the maximum number of active replication origins.

Support buffer forwarding in StartReadBuffers().
Thomas Munro: StartReadBuffers() reports a short read when it finds a cached block that ends a range needing I/O by updating the caller's *nblocks.

Support buffer forwarding in read_stream.c
Thomas Munro: In preparation for a follow-up change to the buffer manager, teach read_stream.c to manage buffers "forwarded" from one StartReadBuffers() call to the next after a short read.

doc: Remove incorrect description about dropping replication slots
Fujii Masao: pg_drop_replication_slot() can drop replication slots created on a different database than the one where it is executed.

Show plperl version in the meson setup summary
Andrew Dunstan: Also, use perl 'version' instead of 'api_versionstring' to sync with the configure script.

Add an additional hook for EXPLAIN option validation
Robert Haas: Commit c65bc2e1d14a2d4daed7c1921ac518f2c5ac3d17 made it possible for loadable modules to add EXPLAIN options.

Add vacuum_truncate configuration parameter
Nathan Bossart: This new parameter works just like the storage parameter of the same name: if set to true (which is the default), autovacuum and VACUUM attempt to truncate any empty pages at the end of the table.

pg_createsubscriber: Add -R publications option
Amit Kapila: This patch introduces a new '-R'/'--remove' option in the 'pg_createsubscriber' utility to specify the object types to be removed from the subscriber.

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

extension_control_path
Peter Eisentraut: The new GUC specifies a path to look for extension control files.

Add ALTER TABLE ... ALTER CONSTRAINT ... SET [NO] INHERIT
Álvaro Herrera: This allows to redefine an existing non-inheritable constraint to be inheritable, which allows to straighten up situations with NO INHERIT constraints so that thay can become normal constraints without having to re-verify existing data.

Add connection establishment duration logging
Melanie Plageman: Add log_connections option 'setup_durations' which logs durations of several key parts of connection establishment and backend setup. For an incoming connection, starting from when the postmaster gets a socket from accept() and ending when the forked child backend is first ready for query, there are multiple steps that could each take longer than expected due to external factors.

Add WAL data to backend statistics
Michael Paquier: This commit adds per-backend WAL statistics, providing the same information as pg_stat_wal, except that it is now possible to know how much WAL activity is happening in each backend rather than an overall aggregate of all the activity.

Enforce memory limit during parallel GIN builds
Tomas Vondra: Index builds are expected to respect maintenance_work_mem, just like other maintenance operations.

Fix snapshot used in logical replication index lookup
Heikki Linnakangas: The function calls GetLatestSnapshot() to acquire a fresh snapshot, makes it active, and was meant to pass it to table_tuple_lock(), but instead called GetLatestSnapshot() again to acquire yet another snapshot.

doc: Expand version compatibility for pg_basebackup features
Daniel Gustafsson: This updates the paragraph on backwards compatitibility for server features to include --incremental which only works on servers with v17 or newer.

Use extended stats for precise estimation of bucket size in hash join
Alexander Korotkov: Recognizing the real-life complexity where columns in the table often have functional dependencies, PostgreSQL's estimation of the number of distinct values over a set of columns can be underestimated (or much rarely, overestimated) when dealing with multi-clause JOIN.

Modularize log_connections output
Melanie Plageman: Convert the boolean log_connections GUC into a list GUC comprised of the connection aspects to log. This gives users more control over the volume and kind of connection logging. The current log_connections options are 'receipt', 'authentication', and 'authorization'.

PostgreSQL

Today's Activity

Yesterday's Activity

Other Activity This Week

PostgreSQL Release Tags

Most Popular In The Past Month