Issue 386 - The most popular Postgres items of 2020 (15)

Highly Available PostgreSQL with Physical Replication — This white paper discusses the scenarios when designing a High Availability architecture for PostgreSQL. It looks at the desirable features and benefits of delivering High Availability in a business environment. Download white paper.

How Does Postgres Fare on the Arm-Based M1 MacBook Pro? — Apple has begun to roll out machines using its own Arm-based M1 CPUs and the initial performance improvements have been impressive. But while macOS runs faster than ever, what about Postgres? Spoiler alert.. wow?

Postgres Observability: A Diagram of Views and Functions for Observing Postgres — An interactive diagram that provides a simplified view of system views and functions relevant to monitoring Postgres and tracking statistics. This is a Postgres 13 flavored update of a previous effort and Alexey explains more here.

Crunchy Bridge: More Postgres Power, Less Administration — A better option for your Postgres hosting. With a rich set of extensions like PL/Python + SciPy/NumPy/Pandas and more on demand, Crunchy Bridge is made for modern apps. Built by Postgres experts and the team who brought you Heroku Postgres.

pgtools: A Visual Way to Monitor Database Events in Real Time — A very new project built in Python and using Vue.js on the client side.

Postgres Pagination Approaches — Most webapp users don’t want to see a list of thousands of items at once, so pagination is often adopted as a way to ‘page’ through a larger group of items in more manageable chunks. There are several ways to achieve this with Postgres with various tradeoffs.

Postgres 13 Incompatibilities To Be Be Aware Of — Postgres 13 will be in general release soon (it’s currently in beta) and while Postgres tends to be reasonably backward compatible over time, there are some changes worth being aware of before you make a migration, as seen here.

How One Word in Postgres Unlocked a 9x Performance Improvement — The creator of a personal finance tool experienced a user whose data caused a flood of INSERTs large enough to cause a problem. Here’s the tale of how a simple RETURNING clause enabled a huge optimization in the process.

PgHero 2.5: A Performance Dashboard for Postgres — Built in Ruby. And, yes, we have a newsletter for that. 😁

pgModeler: A Postgres Database Modeler — An easy way to create and edit database models in a visual way. It’s packaged up as a paid product but is also open source so you can build your own.

Postgres Explain Visualizer 2: A Vue.js Component to Show Execution Plans — Less a standalone tool and something you’d use when building your own Postgres tooling. There is, however, a demo here. The output is really nifty.

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 🤭

pg_flame: A Flamegraph Generator for EXPLAIN ANALYZE's Output — Reads a JSON query plan from stdin and writes the HTML for the flamegraph HTML to stdout. Available to use via Docker, if you want to keep things simple.

pg_timetable: Advanced Postgres Job Scheduling — A new job scheduler for Postgres implemented from scratch in Go that’s not just about running single queries at set times but that can also execute more complicated sequences of operations. GitHub repo.

A Tool to Make PostgreSQL's EXPLAIN ANALYZE More Readable — A tool that lets you paste in the result of EXPLAIN ANALYZE queries and then see a more easily understandable version.