Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Yesterday's Activity

Make collation-aware system catalog columns use "C" collation
Tom Lane: Up to now we allowed text columns in system catalogs to use collation "default", but that isn't really safe because it might mean something different in template0 than it means in a database cloned from template0.

Other Activity This Week

Drop support for getting signal descriptions from sys_siglist[].
Tom Lane: It appears that all platforms that have sys_siglist[] also have strsignal(), making that fallback case in pg_strsignal() dead code.

Create a separate oid range for oids assigned by genbki.pl
Andres Freund: The changes I made in 578b229718e assigned oids below FirstBootstrapObjectId to objects in include/catalog/*.dat files that did not have an oid assigned, starting at the max oid explicitly assigned.

Drop no-op CoerceToDomain nodes from expressions at planning time
Tom Lane: If a domain has no constraints, then CoerceToDomain doesn't really do anything and can be simplified to a RelabelType.

Recent Activity

Make collation-aware system catalog columns use "C" collation
Tom Lane: Up to now we allowed text columns in system catalogs to use collation "default", but that isn't really safe because it might mean something different in template0 than it means in a database cloned from template0.

Drop support for getting signal descriptions from sys_siglist[].
Tom Lane: It appears that all platforms that have sys_siglist[] also have strsignal(), making that fallback case in pg_strsignal() dead code.

Create a separate oid range for oids assigned by genbki.pl
Andres Freund: The changes I made in 578b229718e assigned oids below FirstBootstrapObjectId to objects in include/catalog/*.dat files that did not have an oid assigned, starting at the max oid explicitly assigned.

Drop no-op CoerceToDomain nodes from expressions at planning time
Tom Lane: If a domain has no constraints, then CoerceToDomain doesn't really do anything and can be simplified to a RelabelType.

Ensure cleanup of orphan archive status files
Michael Paquier: When a WAL segment is recycled, its ".ready" and ".done" status files get also automatically removed, however this is not done in a durable manner.

Add timestamp of last received message from standby to pg_stat_replication
Michael Paquier: The timestamp generated by the standby at message transmission has been included in the protocol since its introduction for both the status update message and hot standby feedback message, but it has never appeared in pg_stat_replication.

postgres_fdw: Improve cost and size estimation for aggregate pushdown
Etsuro Fujita: In commit 7012b132d07c2b4ea15b0b3cb1ea9f3278801d98, which added aggregate pushdown to postgres_fdw, we didn't account for the evaluation cost and the selectivity of HAVING quals attached to ForeignPaths performing aggregate pushdown, as core had never accounted for that for AggPaths and GroupPaths.

Add a --socketdir option to pg_upgrade
Tom Lane: This allows control of the directory in which the postmaster sockets are created for the temporary postmasters started by pg_upgrade.

Add support for NO_INSTALLCHECK in MSVC scripts
Michael Paquier: When fetching a list of tests for a given extension in contrib/ or src/test/modules/, NO_INSTALLCHECK now gets checked first.

Add CSV table output mode in psql
Tom Lane: "\pset format csv", or --csv, selects comma-separated values table format.

PostgreSQL Release Tags

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

Add support for NO_INSTALLCHECK in MSVC scripts
Michael Paquier: When fetching a list of tests for a given extension in contrib/ or src/test/modules/, NO_INSTALLCHECK now gets checked first.

Add CSV table output mode in psql
Tom Lane: "\pset format csv", or --csv, selects comma-separated values table format.

Add a 64-bit hash function for type citext
Tom Lane: Amul Sul, reviewed by Hironobu Suzuki

Remove WITH OIDS support, change oid catalog column visibility
Andres Freund: Previously tables declared WITH OIDS, including a significant fraction of the catalog tables, stored the oid column not as a normal column, but as part of the tuple header. This special column was not shown by default, which was somewhat odd, as it's often (consider e.g.

Add a 64-bit hash function for type hstore
Tom Lane: There's some question about the correctness of the hash function, but if it's wrong, the 32-bit version is also wrong.

Rework the pgbench state machine code for clarity
Alvaro Herrera: This commit continues the code improvements started by commit 12788ae49e19.

Fix float-to-integer coercions to handle edge cases correctly
Tom Lane: ftoi4 and its sibling coercion functions did their overflow checks in a way that looked superficially plausible, but actually depended on an assumption that the MIN and MAX comparison constants can be represented exactly in the float4 or float8 domain.

Integrate recovery.conf into postgresql.conf
Peter Eisentraut: recovery.conf settings are now set in postgresql.conf (or other GUC sources).

Clamp semijoin selectivity to be not more than inner-join selectivity
Tom Lane: We should never estimate the output of a semijoin to be more rows than we estimate for an inner join with the same input rels and join condition; it's obviously impossible for that to happen.

Add a --socketdir option to pg_upgrade
Tom Lane: This allows control of the directory in which the postmaster sockets are created for the temporary postmasters started by pg_upgrade.

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