Postgres index types (and where to find them)

Short, popular 30 minute video of engineer Louise Grandjonc’s talk at DjangoCon: all about Postgres indexes, from B-tree to GIN to GiST to BRIN. Featuring crocodiles, because Louise’s technical talks are never boring.
Watch the video → 

Taking the temperature of Postgres with these 4 system metrics

A dive into four key system utilization metrics and what they can tell you about what’s happening with your Postgres server.
Read Rachel's post → 

Postgres for those who can’t even: working with Node and JSON

Part 2 of a series of blog posts that Rob Conery is writing for a friend; Rob’s friend is a Javascript developer who knows next to nothing about Postgres. This series is Rob’s attempt to help people get started with Postgres from the absolute beginning.
Read and share Rob's post → 

Postgres 13 news from committer Peter Geoghegan

Link to a Twitter thread from Postgres developer Peter Geoghegan (@petervgeoghegan) about what he committed to Postgres 13 this week: deduplication. His tweet also includes a link to new docs on the internals.
Read Peter's twitter thread → 

How to use QGIS with Azure Database for PostgreSQL & PostGIS

QIS is open source desktop GIS software, useful for visualization and analysis of geospatial data. This guest post is all about how to use QIS in combination with Azure Database for PostgreSQL and the PostGIS extension to Postgres.
Read more on the Azure Postgres blog → 

#sketchnotes of recent Craig Kerstiens talk, “Postgres at any scale”

Craig recently gave a talk at the Birmingham on Rails developer conference about Postgres at any scale—and this lovely #sketchnotes gives a visual outline of the key takeaways. Many thanks, Evan Travers.
Check out the #sketchnotes → 

Over 13K pageviews for this story on how Microsoft uses Citus (even before the acquisition)

While many Citus open source users have smaller databases on the order of GBs or TBs, this blog post is a story about a bigger database, about how engineer Min Wei architected petabyte scale analytics by scaling out Postgres on Azure with the Citus extension.
Read Claire's post → 

Distributed PostgreSQL is a game changer

This week in Bengaluru, India, our PM Parikshit Savjani gave a PGConf India keynote titled “Distributed PostgreSQL is a game changer.”
See Parik’s PGConf India slides → 

Fibonacci spirals & 21 ways to contribute to Postgres—beyond code

At FOSDEM, where thousands of open source software developers meet every year in Brussels, our PM Claire Giordano gave the kickoff talk in the Postgres devroom—about the many ways to contribute to Postgres, beyond code.
Watch the video →