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? →
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 →
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 →
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? →
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 →
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 →
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.