POSETTE: An Event for Postgres 2025 will happen virtually Jun 10-12, 2025. Call for Speakers is open! 💥
 |
|
|
| Authenticating passwords with SCRAM & channel_binding in Postgres 13 ⟶ Postgres committer Jeff Davis covers the concepts of SCRAM and channel binding—and then shares a step-by-step tutorial on how to set up password authentication in Postgres 13 with SCRAM & channel_binding. BLOG | JEFF DAVIS |
| How to monitor bloat in Postgres with Datadog custom metrics ⟶ Monitoring bloat in Postgres is a thing. Here, Korhan walks you through how to use Datadog custom metrics on Azure to track bloat in Postgres & help you investigate performance issues. BLOG | KORHAN ILERI |
| Virtual lab for creating Hyperscale (Citus) clusters on Azure ⟶ Our new virtual lab—created for PyCon—shows you how to create a Hyperscale (Citus) server group on Azure. Also explores distributed tables, sharding, and parallel queries. More details on GitHub. LAB | COLTON SHEPARD & AARON WISLANG |
| Demo of Postgres & Citus at SIGMOD ⟶ Marco’s impressive performance demo shows how Hyperscale (Citus) can scale by routing transactions to the right node in the cluster. And how you can parallelize analytical queries & data transformations across the Hyperscale (Citus) cluster. VIDEO | MARCO SLOT & CLAIRE GIORDANO |
| Converting 2 billion rows to Bigint with Citus ⟶ ICYMI, well worth a read. With 2 billion rows in distributed Citus tables & an integer primary key set to autoincrement, our customer was heading toward an integer overflow issue. Here’s the play by play. BLOG | COLTON SHEPARD |
| Smartly.io blog about sharding with Citus ⟶ What to do when your Postgres database outgrows the largest possible servers in the cloud? This is our customer Smartly.io’s engineering blog post about how they sharded their 5TB database with Citus. BLOG | MARKUS SINTONEN |
| Propagating user-defined types in Postgres ⟶ Featured in this week's PostgresWeekly, this is all about how user-defined types (aka custom types) and Postgres extensions are propagated to all the nodes in a distributed Citus cluster. BLOG | NILS DIJK |
| Google’s Summer of Code includes WAL-G ⟶ Google’s Summer of Code includes some Postgres projects again this year—and one of the projects aims to improve WAL-G. WAL-G was originally created by Citus engineers Katie Li & Daniel Farina, and we love seeing WAL-G continue to develop. BLOG | ANDREAS SCHERBAUM |
| Postgres engineering intern uses SQLancer to find this Postgres bug ⟶ There are many ways to contribute to Postgres and one way of course is to report bugs. Using SQLancer, our summer engineering intern Nazli Ugur Koyluoglu discovered a timing issue with ALTER TABLE’s validate constraint. And Postgres committer David Rowley fixed it. Teamwork. :) EMAIL | NAZLI UGUR KOYLUOGLU & DAVID ROWLEY |
| ICYMI: Citus 9.3, our latest open source release ⟶ All the things new to Citus 9.3, including new window function features, adaptive connection management, shard pruning, INSERT..SELECT features, and a lower memory (hence faster) pg_dump. Enjoy. BLOG | CLAIRE GIORDANO |
| On Wed 05 Aug, virtual meetup on PostgreSQL at any scale, ft. Citus ⟶ At 17:00 in CET time on Wed 05 Aug, Marco Slot will give a talk about the internals of Citus, along with a live demo on Azure to show you you can use Hyperscale (Citus) to power data-intensive apps. ONLINE TALK | MARCO SLOT |
| You May Also Like |
| Take your spatial analysis to the next level with PostGIS ⟶ BLOG | POSTGIS, SPATIAL DATA, EXTENSIONS |
| Five ways to paginate, from basic to exotic ⟶ BLOG | PAGINATION, PERFORMANCE, KEYSET, CURSORS, LIMIT-OFFSET |
| Real-time analytics tutorial with Hyperscale (Citus) ⟶ DOCS | REAL-TIME ANALYTICS, AZURE, CITUS |
| Five types of database sharding and which is right ⟶ BLOG | SHARDING, TENANT, GEOGRAPHY, TIME |
| Prepay for Reserve Capacity on Hyperscale (Citus) on Azure ⟶ DOCS | PRICING, RESERVE CAPACITY, RESERVE INSTANCES |
| Not all Postgres connection pooling is equal ⟶ BLOG | CONNECTIONS, RAILS, PGBOUNCER |
|
|
| Events & Conference Talks |
| Upcoming Citus talk on Wed 05 Aug ⟶ Marco Slot will be giving an online talk (with demo) about scaling out Postgres with the Citus extension, showing you how you can use Citus to power data-intensive applications. |
| Running Postgres-as-a-Service in Kubernetes ⟶ Lukas Fittl’s slides from his talk at the Linux Foundation Open Source Summit in June. Postgres & Kubernetes, together. |
| JSONB Tricks: Operators, Indexes, and When to (Not) Use It ⟶ Colton loves JSONB. Here are slides from his latest talk at the SF Bay Area PostgreSQL Meetup. |
| PGConfEU 2020 has been cancelled :( ⟶ The leaders of the annual PGConfEU event (one of our favorites) have made the painful decision to cancel. Magnus Hagander explains why. |
| Citus co-founder’s talk on Azure & Postgres ⟶ Slides from Umur Cubukcu’s recent European Open Source Summit talk, all about his mission to make Azure the best destination to run Postgres. |
| Microsoft Ignite in September ⟶ We’re working right now on creating Postgres content for the upcoming (virtual) Microsoft Ignite event in September. Sign up here to stay in the loop about schedules & sessions. |
|
|
| Is Citus right for you? |
| Want to explore whether Citus is right for you and your use case? Download Citus open source, check out the documentation, or watch this short demo of Hyperscale (Citus) on Azure Database for PostgreSQL. |