Join our public Slack channel

DYK we have a public Slack channel? It gives you direct access to our engineers, customers, users, and community members—to help you out when you need it.
Join us!  → 

12 Factor: Dev/prod parity for your database

The 12 factor app changed how we build SaaS apps. One of these 12 factors is a challenge when it comes to databases: Dev/prod parity. You can run the same version of your database, and have a sandbox copy, but testing & staging with production data is a challenge. In this post, Craig explains why Dev/prod parity is easy, until it’s not.
More about 12 Factor and databases → 

PostgreSQL 11 and Just In Time Compilation of Queries

This post about one of Postgres 11’s new features, the Just in Time compiler, hit the front page of Hacker News a couple weeks ago. Andres Freund has been working on the query executor engine for a while now, and in the next PostgreSQL release we’ll see the new JIT compiler. In this post, Dimitri provides the results of the TPC-H benchmark he performed using the new compiler.
See the benchmark results →

How PersistIQ reduced response times for 97% of queries to less than 500ms, for their multi-tenant SaaS app

PersistIQ uses Citus to scale out Postgres & power the growth of their sales engagement tool, a B2B SaaS application. With the Citus Cloud database as a service, the PersistIQ team can stay focused on their app and forget about their database. And PersistIQ’s multi-tenant Ruby gem integrated seamlessly with Citus Cloud. Nice!
Find out how PersistIQ reduced response times → 

Use cases for followers (aka read replicas) in Postgres

In the Citus Cloud database, read replicas are known as followers. Followers use a full asynchronously updated copy of your database, enabling you to run complex analytics against a production database without impacting performance on production.
All about read replicas in our Citus Cloud database → 

A history lesson on SQL joins (in Postgres)

PostgreSQL is smart enough to realize that different SQL queries can yield the same result. Hence the PostgreSQL planner must find the most efficient way to execute JOINs, both in single-node PostgreSQL and in a distributed Citus database. Dimitri tells all about writing join conditions in SQL.
How to write join conditions → 

Fun with SQL: Unions in Postgres

For those of you who are SQL experts, you know all about the usefulness of the UNION and UNION ALL operators in PostgreSQL. This post by one of our new hires includes examples on how to use these operators to make the most out of these operators in Postgres.
Check out Gary’s freshman post  → 

Brandur’s post on “A Comparison of Advanced, Modern Cloud Databases”

“While unbounded data growth may still be a big problem for many teams, the tools and cloud databases we have today to manage it have never been better.” Yet, it can be a little hard to keep track of the new cloud databases and how exactly each database differs from the next. In Brandur’s comparison matrix of modern cloud databases, of course our Citus database is in the mix, and we fare pretty well. See what you think.
Check out Brandur’s take → 

OH on Twitter: “This guide to faster counting with @postgresql from @citusdata is über useful”

Love love love it when one of our older posts gets some props. It’s a nice reminder that there is a LOT of good info in the Citus blog for both novice and experienced Postgres users.
Thanks Kyle! → 

ICYMI: Postgres data types you should consider using

PostgreSQL has nearly 100 different data types, and these data types can come with their own tuned indexing or their own specialized functions. You probably already use the basics such as integers and text. In this post, we’ll take a survey of less-used but incredibly powerful PostgreSQL data types.
So many Postgres data types → 

Bay Area locals, we gotchu—but not just you

• Join us at the SF Bay Area PostgreSQL Meetup on Oct 16th (we are hosting it at our office!)

• You’ll find us at North Bay Python too

• You going to RedMonk’s Monktoberfest in Oct? Be sure to say hello to Claire Giordano, our head of marketing

• Will you be at PyConFr? Dimitri Fontaine will present ‘Python and Postgres: let’s work together’

• We hope to see you at PGConf EU in Lisbon. Several Citans will giving talks. We’ll have a booth, too.

• Let us know if you’ll be at AWS re:Invent in Vegas. And if you want to setup 1:1 time.

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.