Blog , p.6

Anastasia Lubennikova, a Postgres Pro leading developer, has reported at PGConf.India that  Peter Geoghegan had  committed recently the long-awaited B-Tree index deduplication patch to PostgreSQL.

The conference gathered about 100 people, including PostgreSQL developers, DBA and customers from all over the world.

Postgres Professional delegates are back from PgConf.EU 2017 - the annual European PostgreSQL conference, which took place in Warsaw on October 24-27.

Postgres Pro Standard 9.6.2.1 has been released today. It is based on PostgreSQL 9.6.2 and contains the new upstream fixes and Postgres Pro extensions updates, including pg_pathman, pg_probackup and sr_plan.

This blog compares how PostgreSQL and MySQL handle millions of queries per second.

PostgreSQL 9.6 was released yesterday. This is a great release which provides to users set of outstanding new features. We are especially happy that Postgres Professional did substantial contribution to this release.

This talk gave an overview about the Postgres adoption in 2015 in China.

This talk covers the top ten new features that appeared in the Postgres 9.5 release. It also covers some of the major focuses for post-9.5 releases.

In July 2016 in Minsk, the capital of Belarus, Postgres Professional held educational course for PostgreSQL users and administrators.

What is the scientifically correct way if using NULLs  ?

We are delighted to repost the  article by Citusdata, and appreciate the recogintion of our contribution:  "Special thanks to the people at Postgres Professional  for contributing most of the full-text search, JSONB, and GIN index features in PostgreSQL, as well as the initial code for the Citus COPY feature"

Gilles Darold from the french company Dalibo, the ora2pg author, has blogged that the performance improvement given by the Svetlana's patch can be as high as 45%.

Recently Robert Haas has committed a patch which allows seeing some more detailed information about current wait event of the process. In particular, user will be able to see if process is waiting for heavyweight lock, lightweight lock (either individual or tranche) or buffer pin. The full list of wait events is available in the documentation. Hopefully, it will be more wait events in further releases.

Oleg Bartunov: Today I have feeling, that our developers community needs some nostalgia.

pg_pathman is distributed as PostgreSQL 9.5 extension and available at github