Citus Newsletter

Postgres tips for optimizing Django & Python performance ⟶

Louise has created a great companion to the delightful workshop she developed for PyCon2020 (see ICYMI section below). A good reference for performance traps to avoid, and tools to fix them.

Louise Grandjonc

Change data capture in Postgres: How to use logical decoding and wal2json ⟶

Real-time data updates allow you to keep disparate data systems in continuous sync and to respond quickly to new information. Rachel explains the power of transaction log-based change data capture in this post.

Rachel Agyemang

Spatial SQL with PostGIS and Postgres: What makes spatial queries special? ⟶

Topi pulls together some tips and tricks that are either essential for spatial analytics (e.g. spatial joins) or are useful to understand (e.g. geometry validity) in the context of PostGIS.

Topi Tjukanov

What developers are doing on Postgres & MySQL on Azure ⟶

Watch this video to learn how developers are architecting applications on Postgres (& MySQL) on Azure—for use cases like e-commerce, web content, time series data, real-time analytics, & multi-tenant SaaS.

Samay Sharma & Andrea Lam

PostgreSQL 13 Beta 1 Released ⟶

In case you haven’t heard, PostgreSQL 13 Beta 1 is out! So many new features in functionality, administration, security, and more. Read on for more deets.

Postgres Global Development Group

Inspecting Command Tags and Events in event triggers ⟶

In this post, Luca creates an event trigger debugging use case for more common commands—supplementing the use cases in the official documentation for dropping objects and rewriting tables.

Luca Ferrari

Demo: Building HTAP Applications with Python & Postgres on Azure ⟶

In this demo, Sai shows us how scaling out Postgres with Hyperscale (Citus) enables you to use a single database to serve both transactional and analytical workloads—reducing operational costs, and headaches, in a big way.

Sai Srirampur

Cloud9 conquers esports using Azure data analytics ⟶

Cloud9, a top competitor in the world of esports, is crunching numbers for strategic advantage. They’ve created a platform that uses AI components to mine interactive data from unusual sources. And not surprisingly, Postgres is a key component of the solution architecture.

Cloud9 & Azure

ICYMI: Microsoft Build Top 10 Sessions ⟶

If you didn’t get the opportunity to participate in Microsoft Build, Microsoft’s developer event, Absishek has pulled together a useful list of his Top 10. Spoiler alert - Samay & Andrea’s session made the list.

Abishek Gupta

Video: Optimize your Python & Django apps with Postgres superpowers ⟶

Python, Django, Postgres

Auditing: Know what's going on in your Postgres database ⟶

Security, audit logs, compliance

How the Citus distributed query executor adapts to your Postgres workload ⟶

Adaptive executor, distributed query, performance

PostgreSQL rocks, except when it blocks: Understanding locks ⟶

Locks, ACID transactions

The most useful Postgres extension: pg_stat_statements ⟶

pg_stat_statements, extensions, favorite

Check out Citus on GitHub ⟶

GitHub, Citus, open source

High performance HTAP with Postgres & Hyperscale (Citus) ⟶

Join Marco Slot & Claire Giordano on June 16th at the Microsoft Virtual Open Source Summit for a demo & conversation about high performance HTAP using Postgres & Hyperscale (Citus).

Making Azure the best destination to run Postgres ⟶

Also at the Microsoft European Virtual Open Source Summit, Umur Cubukcu will share why he believes Azure is becoming the best destination for Postgres.

Running Your Own Postgres Database-as-a-Service on Kubernetes ⟶

On June 30th, Lukas Fittl will present at the Linux Foundation Open Source Summit his introduction to the tools available today to run open-source databases, and in particular PostgreSQL, at scale.

The Art of Postgres @ Postgres Vision 2020 ⟶

During Postgres Vision event online later in June, you can catch “The Art of Postgres” presented by Dimitri Fontaine, author of the book of the same name.

Video: JSONB Tricks: Operators, Indexes, and When to (NOT) Use It ⟶

If you missed the SF Bay Area Postgres Virtual Meetup on May 19th, watch this video to see Colton Shepard present his JSONB Tricks.