Citus Newsletter

\watch ing Star Wars in Postgres

In this post, based on a talk he gave at Keep Ruby Weird, Will explains how to watch Star Wars in Postgres. Yes, you read that right. Will uses a variety of Postgres functions in a fun and innovative way to render Star Wars using Postgres.
See for yourself → 

Heap delivers real-time performance on 1.4 PB of raw data (uncompressed)

Heap is quoted as saying that thanks to Citus, they power a product that is really kind of magical. We recently interviewed Heap CTO Dan Robinson to update their case study about how they handle 700B+ events with a 70 node Citus database cluster with 34 TB of memory, to serve over 6,000 Heap customers with fast queries.
Find out how Heap manages 1.4 PB of data → 

The perks of sharing your Citus open source stories

Developers who work with open source will often share not just code but also their stories—about problems they’ve run into and how they’ve solved them. There are lots of reasons to share; some you may not have considered. ;-)
A few reasons to share your story →

Rasty Turek, founder & CEO, shares how Pex powers ultra-fast content search

Since we originally interviewed the founder back in May, Pex has dramatically increased the amount of data processed, with no reduction in performance. Performing analytics on multimedia content across multiple platforms requires some heavy lifting within Pex’s technology stack. Here’s how and why the team at Pex chose the Citus database to scale out Postgres in the cloud.
Read the deets → 

Why the RDBMS is the future of distributed databases

Perhaps the most challenging problem in distributed systems is that of building a distributed database. Here Marco explores why he thinks the RDBMS is the future of distributed databases, and how Citus turns Postgres features into superpowers. From query routing to reference tables to subquery pushdown to stored procedures and functions.
Read Marco’s take on the future of distributed databases → 

Using Postgres and Citus for lightning fast analytics

In case you missed Sai’s webinar earlier this month, you can watch his live demo of how you can use Postgres and the Citus Cloud database as a service to manage real-time analytics workloads. Here are the slides if you’d rather review them at your own pace.
Watch the demo → 

Commenting your Postgres database

In this post, Craig explains how and why to make your SQL and database easy to understand. Comments are one of the most useful aids to understanding. And you know Postgres has a few great mechanisms that can be leveraged to improve your comments.
Commenting tips from Craig → 

PostgreSQL 11 and Just In Time Compilation of Queries

In this post, Dimitri provides the results of the TPC-H benchmark he performed using the new Just in Time compiler, one of Postgres 11’s new features.
See the benchmark results → 

Scaling multi-tenant applications using Django and Postgres—a 5 min video

In this short 5 minute lightning talk, Sai shares how to make your django application tenant-aware. And how to scale out applications that are built on top of the Django ORM.
Watch the video → 

ICYMI: Materialized views vs. rollup tables in Postgres

In this post, Craig explains the difference between materialized views and rollup tables in Postgres, and provides some criteria to help you decide which is best for your data set and workload.
We think rollups scale better. Learn why →