/PostgreSQL

UK COVID-19 Dashboard Built Using Postgres And Citus For Millions Of Users

- Claire Giordano tl;dr: "In this post you’ll learn about the database challenges the team faced as the dashboard needed to scale—with an eye toward how the UKHSA team uses Azure, the Azure Database for PostgreSQL managed service, and the Citus extension which transforms Postgres into a distributed database."

featured in #287

Tricking PostgreSQL Into Using An Insane – But 200x Faster – Query Plan

- Jacob Martin tl;dr: "How PostgreSQL row count estimation can go very wrong. In this case, domain knowledge will help us trick PostgreSQL into a different query plan which will be way faster, without adding any additional indices." Jacob shows us that query plans aren’t that hard to interpret with the right tools and how to rewrite queries to "achieve substantial performance boosts without unnecessary indices or denormalizing the data model."

featured in #284

Lesser Known PostgreSQL Features

- Haki Benita tl;dr: 20 features including: (1) Get the number of updated and inserted rows in an Upsert. (2) Grant permissions on specific columns. (3) Match against multiple patterns, and more.

featured in #268

Best PostgreSQL GUIs in 2021

- Angel D'az tl;dr: Our team of developers researched the best PostgreSQL GUIs in 2021 so you don’t have to. We'll break down the best GUIs for querying, visualizing and analyzing your Postgres data, as well as remotely accessing and navigating database servers.

featured in #263

Psycopg 3.0 Released

- Daniele Varrazzo tl;dr: Leverages more modern PostgreSQL and Python features, such as asynchronous support, server-side parameters binding, prepared statements, and more.

featured in #260

Herding Elephants: Lessons Learned From Sharding Postgres At Notion

- Garrett Fidalgo tl;dr: The inflection point was when the Postgres VACUUM process began to stall consistently, preventing the database from reclaiming disk space. Garrett discusses 3 key decisions the team made and lessons learned: (1) shard earlier. (2) Aim for a zero-downtime migration. (3) Introduce a combined primary key instead of a separate partition key.

featured in #258

PostgreSQL 14 Released!

tl;dr: "This latest release adds to PostgreSQL's trend on improving high performance and distributed data workloads, with advances in connection concurrency, high-write workloads, query parallelism and logical replication."

featured in #256

Postgres 14: It's The Little Things

- Craig Kerstiens tl;dr: "A lot of years Postgres will have some big pillar or theme to the release." However, Craig wants to highlight how the little things are improving too highlighting improvements in JSON syntax, read only roles, psgl and query pipelining.

featured in #254

In Praise Of PostgreSQL

- Drew DeVault tl;dr: "Postgres stands today as one of the most significant pillars of profound achievement in free software, alongside the likes of Linux and Firefox. PostgreSQL has taken a complex problem and solved it to such an effective degree that all of its competitors are essentially obsolete, perhaps with the exception of SQLite."

featured in #243

Better JSON In Postgres With PostgreSQL 14

- Craig Kerstiens tl;dr: "Postgres 14 makes JSON even more user friendly than before. While I wouldn't recommend simply using the subscript format everywhere in your application due to it not always leveraging indexes, for casual querying it proves to be a big win."

featured in #233