Citus Newsletter

What it means to be a Postgres extension

Did you know that years ago, Citus used to be a fork of Postgres? Not anymore. Not for a long while. Citan Jason Petersen recaps the Citus Data journey from fork to Postgres extension and beyond.
What does it mean to be a Postgres extension? → 

Fermi Estimates on Postgres Performance

On the 116th birthday of Enrico Fermi, Citan Samay Sharma outlined his rough estimates (read: Fermi estimates) of what to expect in terms of query performance for Postgres. And if you need to push the boundaries of Postgres beyond a single node, that’s where you can look to Citus to scale out your Postgres database.
Read Samay’s estimates on performance → 

Monitoring your bloat in Postgres

Do you have bloat in your Postgres database? Is your autovacuum well tuned to prevent bloat ballooning? Craig Kerstiens shares a useful query for bloat monitoring.
Read Craig’s post  →

A tour of Postgres index types

Postgres has a number of index types, and with each new release seems to come with another one. In Postgres, while the B-tree index is a common choice (for good reason), there are others. Craig walks through a cheat sheet of Postgres indexes that includes B-tree, GIN, GiST, SP-GiST, BRIN, and Hash indexes.
Take the tour of Postgres index types → 

Indexing all the things in Postgres

Ok, so adding an index to every column of every table is not a best practice for production databases. And it’s definitely not something we recommend at Citus Data, where we take database performance seriously. But indexing all the things is a fun “what if” thought exercise that is well worth thinking about, to understand the value of indexes in Postgres.
What if you indexed all the things? → 

Challenges of Distributing Postgres: A Citus Story at #DataEngConf

Just yesterday in NYC, our CTO Ozgun Erdogan gave a talk at #DataEngConf about the challenges of distributing Postgres. A story of Citus. Great crowd, good questions, and we’ll be sure to share the video when it comes out.
Abstract for Ozgun’s #DataEngConf talk → 

ICYMI: Ozgun’s blog post on Citus 7

Have you heard about Citus 7? Released in September, Citus 7 includes distributed transactions, savepoints, distributed deadlock detection, Rails and Django goodness, and of course Postgres 10 support. Citus 7 is our best yet.
Check out Ozgun’s Citus 7 post → 

Citus in the October spotlight

• Ron Alleyne of Chartbeat on the How and Why of Adopting Citus

• Monitor Your Citus Cluster with VividCortex

• We love tweets like this

• Craig Kerstiens Writes: “Dear Postgres”

Want to get more involved with Citus?

Want to talk about Citus or Postgres or whether our brand of scale-out relational database is right for you? Join our slack channel, check out our documentation, or let us know if you want to book a demo.