Sep 2021 Citus Open Source Newsletter

What’s new in the Citus 10.2 extension to Postgres

Definitive release notes blog post about Citus 10.2, which is ready for PostgreSQL 14. This post also covers new Citus 10.2 capabilities for sharding time series data and for using columnar storage in PostgreSQL.

Read Onder’s post ⟶

Shard rebalancing in the Citus 10.1 extension to Postgres

About the new shard rebalancer capabilities added in Citus 10.1, including ways to monitor the progress of the rebalancer, as well as performance optimizations when Citus is used in combination with Postgres partitioning. Also, space checks.

Read Jelte’s post ⟶

PostgreSQL 14 is out!

PostgreSQL 14 improves high performance and distributed workloads with advances in connection concurrency, high-write workloads, query parallelism and logical replication. You’ll also find innovations on complex data types, including more convenient access for JSON and support for noncontiguous ranges of data. More detail in the release notes.

Read the announcement ⟶

Data Exposed: How to Use Citus to Shard Postgres, for Performance & Scale

In this episode of Data Exposed, Claire shares how Citus uses the Postgres extension APIs to shard Postgres—and the best way to get started with Citus.

Watch the video ⟶

Customer Story: ÖBB uses Azure Database for PostgreSQL to expand its business and improve time to market

In this compelling technical story, you’ll learn how ÖBB, Austria’s largest mobility service provider, decomposed their TicketShop app to 50 containerized microservices and migrated 11TB of data from Oracle to Azure Database for PostgreSQL – Flexible Server. ÖBB is evaluating Hyperscale (Citus) to provide better scale as ÖBB’s applications grow.

Read the story ⟶

Useful Diagnostic Queries

Recently updated with more useful queries this doc includes diagnostic queries for: finding which shard contains data for a specific tenant, finding the distribution column for a table, detecting locks, querying the size of your shards or distributed tables—and so much more.

Read the docs ⟶

Logs in Azure Database for PostgreSQL - Hyperscale (Citus)

PostgreSQL database server logs are available for every node of a Hyperscale (Citus) server group. You can ship logs to a storage server or to an analytics service. The logs can be used to identify, troubleshoot, and repair configuration errors and suboptimal performance.

Read the docs ⟶

Fan of Citus? Star us on GitHub

If you’re an advocate for Citus and how Citus helps developers scale out performance, give us a star. And if you’re new, check out the README.md for an overview…and then give us a star.

Star Citus on GitHub ⟶

Postgres: Boundless `text` and Back Again

Brandur shares why, through experience, he’s returned to using constraints on text fields. While boundless text might be freeing, some problems can arise.

Read Brandur’s post ⟶

Use PGLoader to migrate to Citus

Want to migrate a PostgreSQL database to Citus? This doc explains how you can use PGLoader to implement continuous migration from your PostgreSQL database to Citus.

Read the PGLoader docs ⟶

ICYMI: What’s new in the Citus 10.1 extension to Postgres

Claire explores the operational, performance, and UX improvements in Citus to the shard rebalancer, multi-row INSERTs, adaptive executor, inline VALUES in CTEs, how Citus works with Postgres native partitioning, and more—essentially release notes for the Citus 10.1 extension to Postgres.

Read Claire’s post ⟶