Citus Newsletter

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

The Citus query executor has seen big changes this year. We love Marco's writing, and in this post he explains why we moved to a single unified code path. Also, the secret sauce behind the adaptive executor.

Marco Slot

This video on optimizing Python & Django apps with Postgres is a DELIGHT ⟶

Now live on the PyCon 2020 YouTube channel. Louise's talk is 40 minutes of super-engaging tips on how to find & fix slow queries in your Django apps.

Louise Grandjonc

Interview with the man who creates the Citus docs ⟶

Claire talks to our favorite doc writer Joe Nelson aka "begriffs" to get a backstage peek into why Joe spends his days crafting documentation for Citus open source—and what his favorite bits are.

Claire Giordano

Postgres Projects and Azure Data Studio ⟶

For those who are visually inclined, last year we added a Postgres extension to Azure Data Studio. This post is all about new support in Azure Data Studio for Postgres Projects. To make your life easier.

Swikriti Jain

Using Terraform to create a private endpoint for Postgres ⟶

Your personal step-by-step instructions on how to use Terraform to provision a private endpoint for the managed Postgres service on Azure.

Ramkumar Chandrasekaran

Third in the series about Postgres for those "who can't even" ⟶

Part of a series Rob is writing for a friend who wants to learn Node & Postgres but knows "jack squat" to start. In this post, Rob helps to build an application foundation that will continue to work swimmingly even in 6 months time.

Rob Conery

Video on building geospatial apps on Postgres ⟶

Sai walks us through how to use PostGIS & Postgres on Azure to do site selection for scooter charging stations. I like to play this short 9-minute video at 1.5 speed to increase Sai’s already boundless energy.

Sai Srirampur

Story about the team behind Citus ⟶

Now part of Microsoft, our mission remains the same: to scale out Postgres and to create the world's best Postgres experience, together. This is our team's Citus story.

Citus Team

ICYMI: Citus 9.2 speeds up large scale HTAP workloads on Postgres ⟶

If you’re wondering what’s happening with the Citus extension, the good news is we've started blogging about our latest releases again. Soon Citus 9.3 will come out, but maybe first it's time to read all about 9.2.

Marco Slot

Not all Postgres connection pooling is equal ⟶

Connections consume memory and therefore they are a thing well worth knowing about in Postgres.

Craig Kerstiens

Postgres tips for the average and power user ⟶

psql, psqlrc, pg_stat_activity

Importing spatial data to PostGIS ⟶

PostGIS, shp2pgsql, ogr2ogr, QGIS

Five ways to paginate in Postgres, from the basic to the exotic ⟶

Performance, limit-offset, cursors, keyset pagination

Database sharding explained in plain English ⟶

Sharding, distribution key, multi-tenant

Big welcome to PostgreSQL committers who have joined our team ⟶

Postgres, open source, Thomas Munro, Jeff Davis, Andres Freund

Do you follow @AzureDBPostgres on Twitter yet? ⟶

Twitter, Azure, community

Thomas’s slides on Portability in PostgreSQL ⟶

Rich, detailed slides from Thomas’s talk at the Warsaw PostgreSQL User Group. About portability, from operating systems to malloc to buffered I/O.

Louise’s PyCon slides on optimizing Django apps with Postgres superpowers ⟶

If you watched Louise's awesome PyCon 2020 video and want to see the slides, we've got you covered.

Slides from Sai's Postgres demo for PyCon ⟶

We're chomping at the bit for Sai's HTAP Postgres demo to drop on YouTube. In the meantime, check out Sai's intro slides.

Microsoft Build will be digital in May ⟶

Our talk at Build later in May will be live in 3 different timezones. Topic: What developers are doing with Postgres & MySQL on Azure.

Fabulous PyCon 2020 content going online in Apr & May ⟶

Our team of Python humans at Microsoft has created some awesome digital content for the PyCon community. We hope you like it as much as we do.