---
title: "The Guardian: Bye Bye Mongo, Hello Postgres"
publication: "Postgres Weekly"
issue: 287
published_at: "2019-01-09"
canonical_url: "https://postgresweekly.com/issues/287"
---

The latest Postgres news, articles, tools, and projects.       

#287 — January 9, 2019 

[Read on the Web](https://postgresweekly.com/issues/287)   

Postgres Weekly   

We're back! We hope you enjoyed your holiday break and are looking forward to this year's Postgres developments as much as we are. 

No huge Postgres news from over the break (so no new releases to be upgrading to, then - phew!) but we have launched our new _Tip of the Week_ feature - it's at the bottom of this issue. Thanks to those who've submitted tip ideas, we'll be in touch soon, and if you want to submit your own, [reach out here.](https://cooperpress.typeform.com/to/bTSq7v) 

🐘_Peter Cooper and Craig Kerstiens, editors_    

[PostgreSQL is DB-Engine's 'DBMS of the Year 2018'](https://db-engines.com/en/blog_post/79) — DB-Engines is a popular ranking of database system popularity and they’ve given their annual “DBMS of the Year” accolade to Postgres for the second year in a row. MongoDB and Redis take the silver and bronze. 

Paul Andlinger and Matthias Gelbmann   

[The Guardian: 'Bye Bye Mongo, Hello Postgres'](https://www.theguardian.com/info/2018/nov/30/bye-bye-mongo-hello-postgres) — In April, popular British newspaper _The Guardian_ switched off their MongoDB cluster and completed a migration to PostgreSQL on Amazon RDS. Here’s the full story. 

Philip McMahon   [![\](https://copm.s3.amazonaws.com/11530c7a.png)](https://www.youtube.com/watch?v=sc1EIqwoJLY) 

▶[Will Postgres Live Forever?](https://www.youtube.com/watch?v=sc1EIqwoJLY) — Join the team at EDB as they discuss the innovation that goes into keeping Postgres 30 years young. 

EnterpriseDB sponsor   

[An Overview of Just-in-Time Compilation (JIT) for Postgres](https://severalnines.com/blog/overview-just-time-compilation-jit-postgresql) — Just-in-Time (JIT) compilation is the process of compiling interpreted code into faster native code at runtime in order to improve repeat performance. Postgres added a JIT feature in version 11 although it’s not on by default as _it doesn’t benefit everything._ 

Viorel Tabara   

[8 Anonymization Strategies with Postgres](http://blog.taadeem.net///english/2019/01/03/8_anonymization_strategies_with_postgres) — GDPR may have seemed like a 2018 panic but the demand for improved privacy in data systems is only going to increase, so considering ways to anonmyize data is a good idea. 

Damien Clochard   

[Fun with SQL: Self Joins](https://www.citusdata.com/blog/2019/01/02/fun-with-sql-self-joins/) — Self joins are a simple but occasionally handy notion within SQL allowing you to join a table to _itself_ when some relationship is defined within a single row to another row within that table. 

Craig Kerstiens   

[Postgres's 14 Authentication Methods](https://momjian.us/main/blogs/pgblog/2019.html#January_2_2019) — Did you know it supported so many? They come in six types. 

Bruce Momjian   

[Dealing with a Case of Stuck TransactionIDs](http://richyen.com/replication/postgres/2019/01/08/zombie_transactions.html) — What to do if you see _“oldest xmin is far in the past”_ and _“close open transactions soon to avoid wraparound problems”_ popping up in your logs. 

Richard Yen   

[Complete Free Quest for Cloud SQL](https://www.qwiklabs.com/quests/52?locale=en) — Creating instances and querying data. Cloud SQL will give you the knowledge you need to start integrating this service. 

Google Cloud sponsor   

[Configuring Vim for Postgres Development](https://wiki.postgresql.org/wiki/Configuring_vim_for_postgres_development) — A new page on the official Postgres wiki. 

Nikolay Shaplov   

[HypoPG 2.0 Beta Release](https://github.com/HypoPG/hypopg) — HypoPG is an extension which supports hypothetical indexing and recommendations for Postgres. The 2.0 version is now here which adds support for hypothetical partitioning in Postgres 10 and above. 

PostgreSQL GLobal Development Group      supported by [![\](https://res.cloudinary.com/cpress/image/upload/v1545063289/bkstenhmiu980jk1l71b.png)](https://www.citusdata.com/?utm_source=PG_Weekly&utm_medium=email&utm_campaign=sponsor_blog)  

💡 Tip of the Week  

Welcome to our newest feature for 2019 - a handy, weekly Postgres-related tip. We're starting out with something simple — a way to look at your Postgres server's settings that's better than trawling through _postgresql.conf_. 

First, head into `psql` or any client where you can issue a query. Then run this query: 

`SHOW ALL;` 

You'll get a (pretty long) response beginning like so:  ![](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/gt3zmrgglnbkhjwdqowq.jpg)  

Not only do you get to see the setting names and their values, but also a _description_ of what the setting is for or does.  

This _Tip of the Week_ is sponsored by [Citus Data](https://www.citusdata.com/?utm_source=PG_Weekly&utm_medium=email&utm_campaign=sponsor_blog), the creators of worry-free Postgres that is built to scale out. [Learn more](https://www.citusdata.com/blog/?utm_source=PG_Weekly&utm_medium=email&utm_campaign=sponsor_blog) in the Citus Data blog. 

If you have any ideas for your own tips, [reach out here](https://cooperpress.typeform.com/to/bTSq7v) - we'll pay $50 for your tip if we use it in an issue.          

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom