---
title: "#247: Postgres is the most loved RDBMS "
publication: "Postgres Weekly"
issue: 247
published_at: "2018-03-14"
canonical_url: "https://postgresweekly.com/issues/247"
---

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

#247 — March 14, 2018 

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

Postgres Weekly  

[Three Database Modelling Anti-Patterns](https://tapoueh.org/blog/2018/03/database-modelization-anti-patterns/) — Looking into some classic anti-patterns: entity attribute values, multiple values in a single column, and how using UUIDs can be an anti-pattern too. 

Dimitri Fontaine   

[Postgres, The Most Loved RDBMS](https://blog.2ndquadrant.com/postgresql-loved-rdbms/) — StackOverflow’s 2018 survey [results](https://insights.stackoverflow.com/survey/2018/#technology-most-loved-dreaded-and-wanted-databases) are out. Postgres is the ‘most loved’ _relational_ database (though Redis pips it). 

Simon Riggs   [![\](https://copm.s3.amazonaws.com/6d5206d8.png)](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyP) 

[Real-Time Postgres Performance Monitoring](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyP) — Collect out-of-the-box and custom Postgres metrics and correlate them with data from across your distributed infrastructure and applications. Gain real-time performance insights and set intelligent alerts with Datadog. [Try it free](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyP). 

Datadog sponsor   

[Migrating Production from MariaDB Galera to Postgres and Patroni](https://behind.pretix.eu/2018/03/11/mysql-to-postgres/) — A thorough explanation of a major migration from MariaDB using Galera, a multi-master clustering system, to Postgres using the [Patroni](https://github.com/zalando/patroni) high-availability toolkit. 

Raphael Michel.   

[What Full-Text-Search Has to Do with VACUUM](https://www.cybertec-postgresql.com/en/what-postgresql-full-text-search-has-to-do-with-vacuum/) — You might think they’re very separate topics but this post demonstrates how vacuuming can affect the performance of GIN indexes used by FTS. 

Hans-Jürgen Schönig   

[Patching Plain Postgres for Parallel PostGIS Plans](https://carto.com/blog/inside/postgres-parallel/) — Stock Postgres 10 with PostGIS 2.4 doesn’t parallelize spatial queries well but it’s possible to improve things with some tinkering. 

Paul Ramsey   

[Creating a Data Redaction Capability to Meet GDPR Requirements](https://medium.com/enterprisedb/creating-a-data-redaction-capability-to-meet-gdpr-requirements-using-edb-postgres-30f06b59d425) — The _General Data Protection Regulation_ is a new EU law for data protection. 

Marc Linster and Renee Deger   

[Register Now: Postgres Vision 2018](http://postgresvision.com/) 

EnterpriseDB sponsor   

[New Features for Sequences in PG 10: Gains and Pitfalls](https://www.cybertec-postgresql.com/en/sequences-gains-and-pitfalls/) 

Laurenz Albe   

[Migra: Postgres Migrations Made Almost Painless](https://github.com/djrobstep/migra) — It’s like ‘diff’ but for Postgres schemas and can help make migration systems easier to build. 

Robert Lechte   

[vipsql: A Vim Plugin for Interacting with 'psql'](https://github.com/martingms/vipsql) 

Martin Gammelsæter   

[20 Years and Still Strong: Postgres Services & Support](http://the.postgres.company) 

Command Prompt, Inc. sponsor   

[pg_listen: Trigger A Shell Command from NOTIFY](https://github.com/begriffs/pg_listen) — [More on NOTIFY](https://www.postgresql.org/docs/9.1/static/sql-notify.html), if you’re not familiar. 

Joe Nelson  

Events  

[PGConf UK 2018](https://www.postgresql.org/about/event/2224/) — **July 2- 3 (London)** Will be held on July 3, with an optional training day on July 2, and will be hosted at 30 Euston Square.    

[pgDay Israel 2018](http://pgday.org.il/) — **March 19 (Tel Aviv, Israel)** For the second time in Israel PostgreSQL enthusiast from all over the world join together to share their knowledge and experience with existing and/or potential developers and users of PostgreSQL    

[Postgres Vision 2018](http://postgresvision.com/) — **June 5-6 (Boston, USA)** Postgres in the Cloud - Front and center at Postgres Vision 2018.    

[PGDay.IT 2018](https://2018.pgday.it/it/) — **June 28 - 29 (Pacengo di Lazise, Italy)** The Italian conference dedicated to PostgreSQL.    

[PGConf.de](http://2018.pgconf.de/) — **April 13 (Berlin, Germany)** Covering topics for PostgreSQL users, developers, and interested parties, as well as policy makers.    

Golden Oldies ✨  

[Postgres Domain Integrity In Depth](https://begriffs.com/posts/2017-10-21-sql-domain-integrity.html) — Ways to keep your data ‘squeaky clean’ by way of integrity constraints. 

Joe Nelson   

[Getting Started with JSONB](http://www.craigkerstiens.com/2017/03/12/getting-started-with-jsonb-in-postgres/) — Some basics to using Postgres’s powerful binary JSON datatype. 

Craig Kerstiens   

▶[30 Minutes of Ruby and PostgreSQL Database Tricks](https://www.youtube.com/watch?v=N08NHsyaoKM) 

Barrett Clark        

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