PostgreSQL News Digest

Releases

• Postgres Pro Standard 10.1.1 released . All key improvements and new features of Postgres Pro Standard 9.6 DBMS are transferred to this version, some of the errors found are fixed. PostgreSQL 10.1 build for Windows has also been released.
• PgBouncer version 1.8.1 released. Fixed a bug in 1.8: the missing file was added, now PgBouncer is collected from tarball without any problems.
• The driver version psqlODBC 10.01.0000 has appeared . Some corrections and improvements compared to version 10.00.0000. For example, memory leaks are eliminated.

Articles

• In the article Jsonb:
  Dmitry Dolgov ( Zalando ) announced PostgreSQL , MySQL and MongoDB performance on YCSB tests. The processing performance of binary JSON s (JSONB and BSON) was compared. The testing methodology (in the cloud) is detailed, there are conclusions and recommendations.
  Prior to this, the topic was discussed at PGConf.EU 2017 in Warsaw and at other conferences. For example, in the presentation of Oleg Bartunov on the results of YCSB testing in Postgres Professional (slide 81 and on). In these tests, only MongoDB and PostgreSQL were compared on dedicated powerful servers, and the emphasis was placed on high load (thousands of clients at the same time).
• Comparison of the quality of the Firebird , MySQL and PostgreSQL code.
  As experts, authors of the study are the developers of PVS-Studio
• Part 8 of the series Egor Rogov (Postgres Professional): PostgreSQL Indices .
  This time, Egor explains the limitations of the GIN index that allows RUM to overcome.
• In the article What's new in DataGrip 2017.3
  Maxim Sobolevsky from JetBrains talks about a new version of their DataGrip development environment : In this version, there is already support for key PostgreSQL 10 innovations, such as declarative sectioning .
• There's no reason for the postgres, and it's not the technology .
  And this reason is the inertia of the contract system. Opinions of business representatives. Technological component (as stated) in the article is missing.
• Using PostgreSQL arrays with GOLANG .
  Minimum reasoning, maximum code.
• How we built our cluster in a box .
  CyberTec's Ants Aasma talks about building a cluster on patroni .

Blogs and newsletters

• If Postgres Used Threads Instead of Processes?
  A discussion initiated by Konstantin Knizhnik ( Postgres Professional ) about one of the most fundamental, inherent problems of PostgreSQL.

Developments

• The PGConf.Russia 2018 conference will take place on February 5-7 at MSU.

• The Database Technology Conference was held on November 29 in Moscow.
• The PGConf.Asia 2017 conference was held on December 4-6 in Japan.
• Live Rup #RuPostgres: questions and answers with Avito experts. This is just the recent interpretation of live broadcast , which took place on 26 October. 2017. "We decided to make a text transcript of this meeting, enriching it with useful links."
• Another decoding: Report from the “Autumn Postgres” meeting in Raiffeisenbank . Mitap was held on November 13 at the Raiffeisenbank site. The reports also include banking practice ( problems of introducing PostgreSQL into the current infrastructure of the bank: requirements for backup / monitoring / information security), and technological reports: for applied developers under PostgreSQL / Postgres Pro and for those interested in the experience of building a cluster on Corosync / Pacemaker in bundled with PostgreSQL.

Projects and implementations

• Public transport timetable in 2GIS (for PostgreSQL DBMS). The history of creating a working mobile application. And - for today - 76 comments.