Digest news from the world of PostgreSQL. Issue number 5

Feature freeze

This is, of course, the main event for the community. The fact that the just-ended commitfest did not pass will not fall into version 11 of PostgreSQL.

What is frozen on feature freeze
This is our summary of the most important patches.
The summary is a summary, and PostgreSQL 11 articles have already begun to appear. And then - more.
')
Waiting for PostgreSQL 11 - Transforms for jsonb to PL / Python and to PL / Perl
Depesche , that is, Hubert 'depesz' Lubaszewski, writes in his blog about the 2 patches of Anton Bykov from Postgres Professional.

Postgres 11 highlight - Covering Indexes
In his blog, Michel Paquier writes about covering indexes (see also What's new in PostgreSQL 11: Alexander Alexeev ’s INCLUDE indices from Postgres Professional and comments on it). On the same topic - INCLUDE-indexes - article Waiting for PostgreSQL 11: Covering + unique indexes by Alexey Leskovsky from Data Egret.

Partition Elimination in PostgreSQL 11
About this serious achievement of the 11th version, David Rowley of 2ndQuadrant writes in his article .

On another patch, past in PostgreSQL 11, writes in the article What's New in PostgreSQL 11: the built-in web search is the same Alexander Alekseev.

Manipulating checksums of a cluster
Michel Paquier writes about another PostgreSQL 11 patch. The patch checks the page checks after a regular cluster stop. Moreover, it offers its utility pg_checksums based on this patch.

Site redesign

How do you like the new design of PostgreSQL.org readers?

Releases

BDR 3.0
The 2ndQuadrant just announced the release of BDR 3.0. Details are not even on the site. Only in group on Facebook.

pgAdmin 4 version 3.0
The developers (pgAdmin Development Team) claim that there are more than 100 innovations and fixes in the release .
Among the innovations:

• you can sort the data directly in edit mode
• pg_service.conf file support
• Greenplum support

Distributions for Windows and macOS are available, as well as in the form of Python Wheel, Docker Container and in source codes. Download here . After a few days, both the RPM and DEB packages should appear.

Pgpool-II 3.7.3
About this release can be found here . Source codes and RPMs can be downloaded here .
The PostgreSQL pgpool tutorial has just appeared . h. I blog at Severalnines. In the 2nd part will be including fault-tolerant clusters.

pgmetrics 1.2
This is a new version of the command-line application that allows you to extract and visualize PostgreSQL metrics.

Conferences

past

Strike 2018
On April 6 and 7, the VII International IT Conference "Strike" was held in Ulyanovsk. There were as many as 14 sections, among which were first presented: design, business, IoT and - by itself - blockchain. Backend-development flow, Highload, DevOps, DataBase was opened by Oleg Bartunov . And the brain-ringer Anatoly Vesserman was closing down - with his forecasts of development until 2050.

Mitap RuPostgres Live 8
This time, Nikolay Samokhvalov suggested discussing issues with fsync, Postgres 11 feature freeze, and the adventures of the MERGE patch. And also “a steady increase in the popularity of Postgres among startups (and not only)”. More than an hour video on youtube .

Future conferences in Russia

DevConf 2018
This year's conference will be held May 18-19 in Moscow in Digital October.

Highload ++ Siberia
This year, Highload ++ will be held at the Novosibirsk Expo Center on June 25 and 26.

Rit
The Russian Internet Technologies Festival 2018 and all its conferences will be held in Moscow on May 28 and 29 at the Skolkovo School of Management

outside Russia

PGConfNepal 2018
scheduled for May 4-5 in Nepal at the University of Kathmandu.

PGCon 2018 in Ottawa will be held May 29 - June 1.

The 2018 Swiss PGDay will be held in Rapperswil, near Zurich on June 29th. Applications are accepted until April 14, registration until June 28.

PGConf.Brazil 2018 will be held in San Paolo on August 3-4.

Send your ideas and wishes to email: news_channel@postgrespro.ru
Previous issues: # 4 , # 3 , # 2 , # 1