Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Other Activity This Week

pg_dump: Further reorganize getTableAttrs()
Peter Eisentraut: After further discussion after daa9fe8a5264a3f192efa5ddee8fb011ad9da365, reorder the version-specific sections from oldest to newest.

Recent Activity

pg_dump: Further reorganize getTableAttrs()
Peter Eisentraut: After further discussion after daa9fe8a5264a3f192efa5ddee8fb011ad9da365, reorder the version-specific sections from oldest to newest.

doc: Add note about possible performance overhead by enabling track_planning
Fujii Masao: Enabling pg_stat_statements.track_plaanning may incur a noticeable performance penalty, especially when a fewer kinds of queries are executed on many concurrent connections.

Add +(pg_lsn,numeric) and -(pg_lsn,numeric) operators
Fujii Masao: By using these operators, the number of bytes can be added into and subtracted from LSN.

Remove support for timezone "posixrules" file
Tom Lane: The IANA tzcode library has a feature to read a time zone file named "posixrules" and apply the daylight-savings transition dates and times therein, when it is given a POSIX-style time zone specification that lacks an explicit transition rule.

Add parens to ConvertToXSegs macro
Alvaro Herrera: The current definition is dangerous.

Undo double-quoting of index names in non-text EXPLAIN output formats
Tom Lane: explain_get_index_name() applied quote_identifier() to the index name.

Add --no-index-cleanup and --no-truncate to vacuumdb
Michael Paquier: Both INDEX_CLEANUP and TRUNCATE have been available since v12, and are enabled by default except if respectively vacuum_index_cleanup and vacuum_truncate are disabled for a given relation.

pg_dump: Unbreak dumping of aggregates from very old server versions
Peter Eisentraut: Recently broken by d9fa17aa7c34dea66ce64da6fb4c643e75ba452c.

Create by default sql/ and expected/ for output directory in pg_regress
Michael Paquier: Using --outputdir with a custom output repository has never created by default the sql/ and expected/ paths generated with contents from respectively input/ and output/ if they don't exist, while the base output directory gets created if it does not exist.

Avoid using a cursor in plpgsql's RETURN QUERY statement
Tom Lane: plpgsql has always executed the query given in a RETURN QUERY command by opening it as a cursor and then fetching a few rows at a time, which it turns around and dumps into the function's result tuplestore.

PostgreSQL Release Tags

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

Bump PG_CONTROL_VERSION for previous 9.4 changes
Tom Lane: This should have been done in 6bc8ef0b7f1f1df3998745a66e1790e27424aa0c and/or 50e547096c4858a68abf09894667a542cc418315, but better late than never.

Most Popular This Year

Add sort support routine for the inet data type
Peter Geoghegan: Add sort support for inet, including support for abbreviated keys.

Add support for --jobs in reindexdb
Michael Paquier: When doing a schema-level or a database-level operation, a list of relations to build is created which gets processed in parallel using multiple connections, based on the recent refactoring for parallel slots in src/bin/scripts/.

Avoid taking a new snapshot for an immutable simple expression in plpgsql
Tom Lane: We already used this optimization if the plpgsql function is read-only.

Remove obsolete information schema tables
Peter Eisentraut: Remove SQL_LANGUAGES, which was eliminated in SQL:2008, and SQL_PACKAGES and SQL_SIZING_PROFILES, which were eliminated in SQL:2011.

Represent Lists as expansible arrays, not chains of cons-cells
Tom Lane: Originally, Postgres Lists were a more or less exact reimplementation of Lisp lists, which consist of chains of separately-allocated cons cells, each having a value and a next-cell link.

doc: Add support for xref to command and function elements
Peter Eisentraut: Discussion:

Remove configure --disable-float4-byval
Peter Eisentraut: This build option was only useful to maintain compatibility for

Extend the ProcSignal mechanism to support barriers
Robert Haas: A new function EmitProcSignalBarrier() can be used to emit a global barrier which all backends that participate in the ProcSignal mechanism must absorb, and a new function WaitForProcSignalBarrier() can be used to wait until all relevant backends have in fact absorbed the barrier.

Fix nbtree metapage cache upgrade bug
Peter Geoghegan: Commit 857f9c36cda, which taught nbtree VACUUM to avoid unnecessary index scans, bumped the nbtree version number from 2 to 3, while adding the ability for nbtree indexes to be upgraded on-the-fly.

Add gen_random_uuid function
Peter Eisentraut: This adds a built-in function to generate UUIDs. PostgreSQL hasn't had a built-in function to generate a UUID yet, relying on external modules such as uuid-ossp and pgcrypto to provide one.

Legal Disclaimer & Disclosure | Contact Us
Copyright © 2010 - 2020 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).