Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Other Activity This Week

Repair assorted issues in locale data extraction
Tom Lane: cache_locale_time (extraction of LC_TIME-related info) had never been taught the lessons we previously learned about extraction of info related to LC_MONETARY and LC_NUMERIC.

Prevent O(N^2) unique index insertion edge case
Peter Geoghegan: Commit dd299df8 made nbtree treat heap TID as a tiebreaker column, establishing the principle that there is only one correct location (page and page offset number) for every index tuple, no matter what.

Avoid order-of-execution problems with ALTER TABLE ADD PRIMARY KEY.
Tom Lane: Up to now, DefineIndex() was responsible for adding attnotnull constraints to the columns of a primary key, in any case where it hadn't been convenient for transformIndexConstraint() to mark those columns as is_not_null.

Fix slot type issue for fuzzy distance index scan over out-of-core table AM.
Andres Freund: For amcanreorderby scans the nodeIndexscan.c's reorder queue holds heap tuples, but the underlying table likely does not.

Recent Activity

Repair assorted issues in locale data extraction
Tom Lane: cache_locale_time (extraction of LC_TIME-related info) had never been taught the lessons we previously learned about extraction of info related to LC_MONETARY and LC_NUMERIC.

Prevent O(N^2) unique index insertion edge case
Peter Geoghegan: Commit dd299df8 made nbtree treat heap TID as a tiebreaker column, establishing the principle that there is only one correct location (page and page offset number) for every index tuple, no matter what.

Avoid order-of-execution problems with ALTER TABLE ADD PRIMARY KEY.
Tom Lane: Up to now, DefineIndex() was responsible for adding attnotnull constraints to the columns of a primary key, in any case where it hadn't been convenient for transformIndexConstraint() to mark those columns as is_not_null.

Fix slot type issue for fuzzy distance index scan over out-of-core table AM.
Andres Freund: For amcanreorderby scans the nodeIndexscan.c's reorder queue holds heap tuples, but the underlying table likely does not.

pg_dump: Remove stray option parsing support for -o
Andres Freund: I (Andres) missed this in 578b229718e8f, the removal of WITH OIDS support.

Rework handling of invalid indexes with REINDEX CONCURRENTLY
Michael Paquier: Per discussion with others, allowing REINDEX INDEX CONCURRENTLY to work for invalid indexes when working directly on them can have a lot of value to unlock situations with invalid indexes without having to use a dance involving DROP INDEX followed by an extra CREATE INDEX CONCURRENTLY (which would not work for indexes with constraint dependency anyway).

pg_restore: Make not verbose by default
Peter Eisentraut: This was accidentally changed in cc8d41511721d25d557fc02a46c053c0a602fed0.

doc: Add note about generated columns in foreign tables
Peter Eisentraut: Explain that it is not enforced that querying a generated column returns data that is consistent with the data that was stored.

Add vacuum_truncate reloption
Fujii Masao: vacuum_truncate controls whether vacuum tries to truncate off any empty pages at the end of the table.

psql \dP: list partitioned tables and indexes
Alvaro Herrera: The new command lists partitioned relations (tables and/or indexes), possibly with their sizes, possibly including partitioned partitions; their parents (if not top-level); if indexes show the tables they belong to; and their descriptions.

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

REINDEX CONCURRENTLY
Peter Eisentraut: This adds the CONCURRENTLY option to the REINDEX command.

Generated columns
Peter Eisentraut: This is an SQL-standard feature that allows creating columns that are computed from expressions rather than assigned, similar to a view or materialized view but on a column basis. This implements one kind of generated column: stored (computed on write).

doc: Add some images
Peter Eisentraut: Add infrastructure for having images in the documentation, in SVG format.

GSSAPI encryption support
Stephen Frost: On both the frontend and backend, prepare for GSSAPI encryption support by moving common code for error handling into a separate file.

Report progress of CREATE INDEX operations
Alvaro Herrera: This uses the progress reporting infrastructure added by c16dc1aca5e0, adding support for CREATE INDEX and CREATE INDEX CONCURRENTLY. There are two pieces to this: one is index-AM-agnostic, and the other is AM-specific.

Support foreign keys that reference partitioned tables
Alvaro Herrera: Previously, while primary keys could be made on partitioned tables, it was not possible to define foreign keys that reference those primary keys.

Compute XID horizon for page level index vacuum on primary
Andres Freund: Previously the xid horizon was only computed during WAL replay.

Add progress reporting to pg_checksums
Michael Paquier: This adds a new option to pg_checksums called -P/--progress, showing every second some information about the computation state of an operation for --check and --enable (--disable only updates the control file and is quick).

doc: Add note about generated columns in foreign tables
Peter Eisentraut: Explain that it is not enforced that querying a generated column returns data that is consistent with the data that was stored.

postgres_fdw: Perform the (FINAL, NULL) upperrel operations remotely
Etsuro Fujita: The upper-planner pathification allows FDWs to arrange to push down different types of upper-stage operations to the remote side.

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