---
title: "#238: PostgreSQL is DB Engines' 'DBMS of the Year' 2017"
publication: "Postgres Weekly"
issue: 238
published_at: "2018-01-10"
canonical_url: "https://postgresweekly.com/issues/238"
---

Postgres Weekly 238   . 

[Read this on the Web](http://postgresweekly.com/issues/238) 

[Postgres Weekly](http://postgresweekly.com) Issue 238 — January 10, 2018     

[PostgreSQL is DB Engines' 'DBMS of the Year' 2017](https://db-engines.com/en/blog_post/76)Postgres might not be new, but its popularity has increased in the last year, fuelled by some fantastic releases, like Postgres 10, and its newest features. DB Engines#news [Parallel Hash: Coming to PostgreSQL 11?](https://write-skew.blogspot.com/2018/01/parallel-hash-for-postgresql.html)A feature that will allow partial plans to be used on both sides of a join. Thomas Munro#news [PostgreSQL and MySQL’s Peaceful Battle With Today’s Demanding Workloads](https://www.percona.com/blog/2017/01/06/millions-queries-per-second-postgresql-and-mysql-peaceful-battle-at-modern-demanding-workloads/)This blog compares how PostgreSQL and MySQL handle millions of queries per second. Percona#sponsored[![\](https://copm.s3.amazonaws.com/0ad3acef.png)](https://www.percona.com/blog/2017/01/06/millions-queries-per-second-postgresql-and-mysql-peaceful-battle-at-modern-demanding-workloads/) [Key Metrics for Postgres Monitoring](https://www.datadoghq.com/blog/postgresql-monitoring/)Learn how to identify and track key performance metrics in this monitoring guide. Emily Chang [Monitoring Postgres Replication Lag](http://sysadvent.blogspot.co.uk/2017/12/day-12-monitoring-postgres-replication.html)How replication is implemented in PostgreSQL, why you should care about lag, and what to do about it. Kathryn Exline [Saving a Tree in Postgres Using LTREE](http://patshaughnessy.net/2017/12/13/saving-a-tree-in-postgres-using-ltree)Postgres is a great document store, for full text search, for geospatial. And as highlighted here can be used for storing trees or hierarchical data as well. patshaughnessy.​net [20 Years & Still Strong, PostgreSQL Professional Services & Support](https://commandprompt.com/) Command Prompt, Inc.​ #sponsored [The State of VACUUM](http://rhaas.blogspot.com/2018/01/the-state-of-vacuum.html)A look back at the history of VACUUM improvements in recent years, the state of VACUUM as it exists today, and how it might be improved in the future. Robert Haas#opinion [PostgreSQL 10 Generally Available on Heroku](https://blog.heroku.com/postgresql-10-general-availability) Heroku#news [@postgresql: Postgres Gets an Official Twitter Account](https://twitter.com/postgresql) twitter.​com#news [MVCC and VACUUM](http://rhaas.blogspot.com/2017/12/mvcc-and-vacuum.html)MVCC and vacuum are core to how Postgres works. Do you understand them? Can you explain them to others? If you answered no to either this post should help. Robert Haas [PSequel: A Free PostgreSQL GUI Tool for macOS](http://www.psequel.com/)It’s not open source but it’s an attractive tool for working with Postgres nonetheless. psequel.​com#tools [Pgpool-II: Connection Pooling and Load Balancing for Postgres](http://pgpool.net/mediawiki/index.php/Main_Page)New versions of a tool that adds connection pooling, load balancing, and automatic failover to Postgres. SRA OSS, Inc.​ #tools [pg_chameleon 2.0: A MySQL to Postgres Replication System](https://github.com/the4thdoctor/pg_chameleon) Federico Campoli#tools [Linux Cloud Hosting Starting at 1GB of RAM for $5/mo](https://welcome.linode.com/postgres-weekly/?utm_source=cooperpress&utm_medium=sponsored&utm_campaign=postgres-weekly-brief) Linode Cloud Hosting#tools#sponsored    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/238) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK