10 Things I Hate About Postgres — A few weeks ago we featured a cheery ‘Postgres is the world’s best database’ item, but you’ve got to take the rough with the smooth! Rick reminds us that no software is perfect and that even Postgres has flaws 🤭

Rick Branson

Comparing MongoDB vs Postgres over JOINs — An analysis of structuring data in both MongoDB’s NoSQL world and Postgres’s relational world to model a classical employee-department data model. It’s a little apples and oranges but makes some reasonable points and when something has a Turing Award winner’s name on it, it’s a must read.

Michael Stonebraker and Álvaro Hernández

Your Data Is Your Business — PGX can help you tune, scale, and monitor your database to keep it performing under the most extreme and unexpected loads. With over 20 years of PostgreSQL experience, we are ready to help you.

PostgreSQL Experts, Inc. sponsor

Optimizing Postgres Performance Through Config Settings — These settings have been covered a lot over the years, but if you want an up to to date one stop shop, this post covers 5 settings worth tuning to optimize your Postgres server, namely: shared_buffers, wal_buffers, effective_cache_size, work_mem and maintenance_work_mem.

Tom Swartz

Coming to Postgres 13: WAL Monitoring — Another look at a new feature coming to Postgres. Backends will track information relating to WAL generation, pg_stat_statements will be able to track WAL usage, and a new WAL option will be available in the EXPLAIN command. If you want to play early, you’ll need to build from the development snapshots or repo.

Julien Rouhaud

pspg 3.0: A Unix Pager Designed for Postgres Tables — If you use psql you probably use less as your pager, but it doesn’t directly support tabular data. This does. The just-dropped version 3.0 supports communication over named pipes or redirected content (example here).

Pavel Stehule

Faster CI/CD for All Your Software Projects Using Buildkite — See how Shopify scaled from 300 to 1800 engineers while keeping their build times under 5 minutes.

Buildkite sponsor

Postgres 13 to Allow pg_stat_statements to Track Planning Statistics — pg_stat_statements is a module for tracking SQL query execution statistics. Postgres 13 is adding more statistics to what is tracked, specifically around planning and execution times.

Hubert depesz Lubaczewski

Michael Paquier: The PostgreSQL 'Person of the Week' — A brief interview with one of Postgres’s most familiar names. His favorite extension is pg_stat_statements which has already made an appearance in this issue :-)

Andreas Scherbaum