Citus Newsletter

New video of Marco’s talk & demo at the Warsaw PostgreSQL Users Group ⟶

Hot off the press. Video of recent talk/demo on how to scale your data-intensive apps by using Citus & roll-ups. Yet another fun demo from Marco, hope y'all enjoy it.

VIDEO | MARCO SLOT

Bitnami templates for Airflow & CKAN ⟶

All about Bitnami’s collaboration with Microsoft—with links to Bitnami templates for Postgres on Azure, for Apache Airflow and for using CKAN with Hyperscale (Citus).

BLOG | SUNITHA MUTHUKRISHNA

Why the RDBMS is the future of distributed databases ⟶

From the technical lead of our Citus open source team, an exploration of the superpowers you get by distributing Postgres. Useful & readable.

BLOG | MARCO SLOT

Dynamo, Citus, and tradeoffs in distributed databases ⟶

Big welcome to engineer Pino de Candia who just joined our Postgres team at Microsoft. This seemed like the perfect time to re-share Pino’s evergreen post on Dynamo and Citus.

BLOG | PINO DE CANDIA

How to create SQL percentile aggregates with t-digest ⟶

Averages suck. Hence this post on how to use t-digest to calculate percentiles with Postgres. And if you need scale, Matt recommends Citus for creating a nearly infinitely scalable SQL-backed solution.

STACKIFY BLOG | MATT WATSON

How to use wal2json & logical decoding ⟶

Useful post from Rachel on how to use wal2json for log-based change data capture. (Alternately, here’s a lovely tutorial for using debezium with Postgres and Kafka, by Abhishek Gupta.)

BLOG | RACHEL AGYEMANG

Scaling Postgres for time series data ⟶

This video is on Sai's short list of favorite materials if you’re just getting started with Citus. All about using Postgres, Citus, and pg_partman to analyze large volumes of time series data.

VIDEO | CLAIRE GIORDANO & MARCO SLOT

Lab: using Postgres with Python on Azure ⟶

Colton’s lab shows you how to import data into Azure Database for PostgreSQL using python & psycopg2. Once the data is loaded, you get to explore a weather dataset with PostGIS. If you have any feedback on this lab, join our Python discord community to let us know!

VIRTUAL LAB | COLTON SHEPARD

pg_auto_failover with PostgreSQL 12 ⟶

Dimitri recently tweeted that he’s working on docs for the new 1.4 release of pg_auto_failover—and that he can't wait to announce all the new capabilities. Hence we’re re-sharing Dim’s earlier pg_auto_failover post to bring y’all up to speed, in advance of the 1.4 news.

BLOG | DIMITRI FONTAINE

Scaling from 1 to 100,000 tenants ⟶

Database options for scaling out a multi-tenant SaaS app, from proprietary to open source, relational to NoSQL, scale up to scale out.

BLOG | CRAIG KERSTIENS

ICYMI: SCRAM authentication with channel binding ⟶

SCRAM with channel_binding is a variation of password authentication that is almost as easy to use, but much more secure. Jeff’s how-to post shows you how to set up SCRAM with channel_binding in Postgres 13.

BLOG | JEFF DAVIS

Multi-tenancy in CUBA using Citus ⟶

CUBA BLOG | SAAS, MULTI-TENANCY, SHARDING, SPRING, JAVA

Postgres 14 thread on large numbers of connections ⟶

MAILING LISTS | PGSQL-HACKERS, CONNECTION SCALABILITY, SNAPSHOTS

New Postgres Whitepaper ⟶

WHITEPAPER | PERFORMANCE, SCALE, HA, PITR, SECURITY, EXTENSIONS

Monitoring Postgres bloat with Datadog ⟶

BLOG | CUSTOM METRICS, MONITORING DASHBOARDS, BLOAT

Fermi Estimates on Postgres Performance ⟶

BLOG | READS, INSERTS, UPDATES, DELETES, INDEXES

Importing spatial data to PostGIS ⟶

BLOG | POSTGIS, SPATIAL DATA, OPENSTREETMAP, QGIS

Citus & PostgreSQL at any scale ⟶

Slides from Marco’s talk at the Warsaw PostgreSQL User Group.

Postgres index types & where to find them ⟶

Louise Grandjonc’s slides from the Montreal Postgres Meetup. Yes, featuring crocodiles.

Open source & Azure Data, now & next ⟶

Video of Sunil Kamath’s keynote at the Microsoft European Open Source Summit. On how open source fits into our Azure Data efforts.

PGDAY Austria 2020 has been canceled ⟶

Sad news (but not unexpected.) The good news is: PGDay Austria 2021 has already been scheduled.

Microsoft Ignite registration opens 03 Sep ⟶

Microsoft Ignite is going digital this year and will take place on 22-24 Sep. And registration opens later this week, on 03 Sep. Hope you can join us.