Citus Newsletter

Hot off the press: Citus vs Single-Node Postgres video

In this short side-by-side performance comparison of Citus vs. single-node Postgres, our engineer Marco Slot walks through the benefits of using Citus to scale out Postgres. He shines a light on the performance of a 4-node Citus database cluster. Enjoy the bleeps.
Watch the side-by-side comparison  →  

Citus 7.3: Broader SQL coverage, Tableau integration, TopN extension, and more

Citus 7.3 improves support for complex analytical queries, provides integration with Tableau and other BI tools, and supports the open source Postgres extension, TopN. The features in this latest Citus database release are particularly useful for real-time analytics workloads.
Ozgun’s take on Citus 7.3  →  

Raw SQL access for users with row-level security

Postgres 9.5 allows you to restrict data access at the row level, giving you an extra layer of security. Because Citus is an extension to Postgres, we’re able to leverage all the great Postgres features, including row level security. This post walks you through how to set up row level security on a Citus database cluster.
Read more about row level security in Citus  →

Why did ProsperWorks choose Citus to scale out Postgres?

ProsperWorks is the #1 CRM for G Suite. The ProsperWorks team needed a fully-managed cloud database to handle the growth of their user base—without having to re-architect their SaaS application. And with the Citus Cloud database, they found it.
See how ProsperWorks scales out  →  

Contributing to Postgres via patch review

Postgres is an awesome database. Just awesome. And Citus is built on top of Postgres. As a team, our engineers value the foundation Citus is built on and regularly aim to contribute back. Here’s an interesting read on how some of the Citus engineers recently reviewed Postgres patches as part of the PostgreSQL commitfest.
See how Citus engineers review Postgres patches  →  

Custom configuring your Postgres settings on Citus Cloud

Citus Cloud now supports custom configuration of your Citus database clusters on Citus Cloud. You’ll find the new customization tab within your Citus Cloud console. The ability to customize your PostgreSQL config should leave you more enabled than ever when it comes to keeping your app performant and scaling.
Read the post on custom configs in Citus Cloud  →  

Awesome new customer story with Chartbeat

Today, both traditional and digital-native publishers are taking steps to become more data-savvy. By analyzing data on reader behaviors and preferences, publishers can optimize reader engagement and make smarter editorial decisions. Choosing the Citus Cloud database with multi-tenant sharding capabilities helped accelerate the Chartbeat launch and avoid time-consuming development work.
More on how Chartbeat uses Citus   →  

Monitoring your Citus Cloud cluster with Datadog

We’re excited to release turnkey integration for one of the more popular tools out there to monitor Citus Cloud clusters: Datadog. In this post, Craig explains how you can get key stats on your database with our Datadog integration, so you can easily monitor status before issues arise.
Read about Datadog and Citus  →  

ICYMI: TopN—a new open source extension for Postgres

People seem to love lists of the most popular things. Whether it’s the top grossing sales reps or the most visited pages on your website, for most of us, there is usually something for which we want to know the top “N”. Inspired by Algolia, a Citus Data customer, TopN is a new extension to Postgres which we are excited to make available to the PostgreSQL community. In this post, Furkan tells us all the things about TopN.
Learn more about TopN → 

On the Algolia Blog: Building Real-Time Analytics APIs at Scale

To provide near real-time analytics to their customers on billions of search queries per day, Algolia recently redesigned their analytics API from the ground up using the Citus distributed database. In this post, engineer Sylvain Friquet of Algolia explains how.
Read the Algolia engineering blog  →  

Citans sure do talk a lot. More coming in May. And slide decks from recent talks too.

• Ozgun Erdogan at XLDB: SQL, Scaling, and What’s Unique About Postgres

• PGCon Ottawa 2018: How PostgreSQL APIs are Changing the Face of Relational Databases

• And we’ll be at PyCon. Come find us. You can always see where we’ll be, and have been, on our Events page.

• Slides: Distributing Queries the Citus Way by Marco Slot

• Slides: Challenges of Distributing Postgres by Ozgun Erdogan

• Slides: Five Sharding Data Models and Which is Right by Craig Kerstiens

Is Citus right for you?

Want to explore whether Citus is right for you and your use case ? Learn more about the Citus product , check out the documentation , or let us know if you want to book a demo .