| Warsaw PgConf.EU 2017 has finished
Postgres Professional delegates are back from PgConf.EU 2017 - the annual European PostgreSQL conference, which took place in Warsaw on October 24-27.
| Millions of Queries per Second: PostgreSQL and MySQL’s Peaceful Battle at Today’s Demanding Workloads
This blog compares how PostgreSQL and MySQL handle millions of queries per second.
| PostgreSQL 9.6 is Released: Contribution of Postgres Professional
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.
| Galy Lee at PgConf2016 Russia presented a talk «Growing acceptance of PostgreSQL in China» - Video
This talk gave an overview about the Postgres adoption in 2015 in China.
| Bruce Momjian at PgConf2016 Russia with talk «Postgres Going in Multiple Directions» - Video
This talk covers the top ten new features that appeared in the Postgres 9.5 release. It covers some of the major focuses for post-9.5 releases.
| DBA1: Free PostgreSQL Course In Minsk
In July 2016 in Minsk, the capital of Belarus, Postgres Professional held educational course for PostgreSQL users and administrators.
| Scalable Real-time Product Search using PostgreSQL with Citus
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"
| Monitoring Wait Events in PostgreSQL 9.6
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.
| Postgres developers (retrospective in pictures)
Oleg Bartunov: Today I have feeling, that our developers community needs some nostalgia.
| Beta-release of pg_pathman partitioning extension
pg_pathman is distributed as PostgreSQL 9.5 extension and available at github
| Scaling PostgreSQL at multicore Power8
Recently, we got access to a big server: IBM 9119-MHE with 8 CPUs * 8 cores * 8 threads. We decided to take advantage of this and investigate the read scalability of postgres (pgbench -S) at this server.
-
-
Thems