Feb 2018 Newsletter from the Postgres people at Citus Data

When Postgres blocks: 7 tips for dealing with locks

Some useful tips from Marco Slot for dealing with Postgres locks. We picked up these tips when collaborating with users who migrated from single node Postgres to Citus—and with users who were building real-time analytics apps on Citus.
Read the 7 tips from Marco →

Distributing Postgres with a Distributed Team at Citus Data

Our Citus engineering team is spread across 5 countries and 6 different cities. So our co-founder Sumedh decided to share his learnings from building our distributed team of distributed database engineers. Enjoy.
Sumedh’s post on distributed teams →

Three Approaches to PostgreSQL Replication and Backup

This post from Ozgun about Postgres replication hit the front page of Hacker News last week. When we talk to Citus users, we often hear questions about setting up Postgres high availability (HA) clusters and managing backups. How do you handle replication and machine failures? What challenges do you run into when setting up Postgres HA? Ozgun tells all about the 3 approaches to replication in PostgreSQL.
Read Ozgun’s post →

Using Hibernate and Spring to Build Multi-Tenant Java Apps

Hibernate officially supports two multi-tenancy mechanisms. Unfortunately, both come with downsides in terms of scaling. This post is all about a 3rd mechanism: tenant discriminator. The Hibernate tenant discriminator model works well as you start small on single-node Postgres. Even better, tenant discriminator can scale as your data grows (with help from Citus.)
Read guest blogger Joe Kutner’s post →

PostgreSQL rocks, except when it blocks: Understanding locks

One problem we often see users struggle with in Postgres: locks. While Postgres is amazing at running multiple operations at the same time, there are a few cases in which Postgres needs to block an operation using a lock. @marcoslot takes the mystery out of Postgres locking behaviors.
Read the post on Postgres locks →

How the Citus distributed database rebalances your data

One of the newer capabilities in Citus is the online nature of our shard rebalancer. The logical replication feature, new to Postgres 10, laid the foundation for us to improve the user experience for our shard rebalancer. So you can scale out a cluster seamlessly and rebalance your database with zero downtime. In this post Craig explains how it all works.
Read Craig’s post →

Using Citus to build Real-Time Analytics apps

Late last year, we created a new page to explain how developers building real-time analytics pipelines use Citus to get performance, at scale. Please let us know what you think—suggestions about how to make our website more useful are always welcome.
About Citus & real-time analytics →

Already a fan of Citus? Star us on GitHub!

Since founding Citus Data back in 2011, we’ve had the privilege to collaborate with some pretty awesome developers, PostgreSQL people, product managers, marketers, salespeople, designers, writers, investors. Most importantly, our customers & users. We could not have gotten to where we are today without your support. If you’re already a fan of Citus, please be sure to star us on GitHub and let the world know. :)
Star Citus on GitHub →

ICYMI: Database sharding in plain English

In building Citus, we’ve picked up a thing or two about sharding Postgres. :) And our engineers are often asked to walk people through what sharding is, and how it works. Here’s how Craig explains it, in plain English.
All about sharding →

We’re giving a whole lot of conference talks (around the globe) in March. Come find us!

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.