June 2016 Newsletter from Citus Data

Citus 5.1 Release

Earlier this year we unforked Citus from PostgreSQL and released version 5.0 as open source. Since then we’ve been busy improving Citus’ usability and performance, starting with data ingestion. Our newly released version 5.1 supports the COPY command, with observed performance of up to a million inserts per second.

PG Conf Silicon Valley

PG Conf Silicon Valley is happening again this year and we look forward to another great conference exploring all thats possible with Postgres. If you have something interesting to say about Postgres we’d love to hear from you. The CFP is currently open. Additionally, early bird tickets now on sale, grab yours today!

Try an example with Citus

Citus is well suited for real-time analytic workloads. To show how a web application works with Citus on the backend we created an example of building an ad analytics dashboard. You can try our demo Rails application and inspect its code. The GitHub repository includes a link to easily run your own instance of the application on Heroku which you can connect to Citus Cloud.

On the Blog

Scaling Out MySQL with PostgreSQL and Citus

In this post Eren Başak examines how to scale MySQL using...Postgres! By matching MySQL table partitions with Citus shards through a foreign data wrapper Eren achieves an impressive speedup. In general this technique brings Citus’ parallel query planning and horizontal scaling capabilities to bear on any data source equipped with a foreign data wrapper.

COPY into distributed PostgreSQL tables, up to ~7M rows/sec

Citus 5.1, as we mentioned earlier, includes some great improvements for data ingestion. This article walks you how to start a Citus cluster and import data in parallel, rivaling the import speed of very large NoSQL clusters.

Upcoming Events

GoRuCo

June 25
Will Leinweber will be presenting an intro to Crystal. Of all the new compiled languages, Crystal is the only one that shares his value of developer happiness. The syntax and idioms are entirely Ruby inspired. Although Crystal looks very similar to Ruby, there are big differences between the two. Crystal is statically typed and dispatched. While there are no runtime dynamic features, the compile-time macros solve many of the same problems. In this session, we’ll take a close look at these differences as well as the similarities, and what Ruby developers can learn from this exciting language.

PG Conf UK

July 5
Marco Slot will be presenting on how to analyze GitHub events data with Citus. This talk will show you how to use PostgreSQL with Citus to do fast analytical queries on a large amount of GitHub data, using JSONB, GIN Indexes and pre-processing the data inside the database. We will also discuss the trade-offs you need to make when setting up a distributed database.

PyGotham

July 17
Craig Kerstiens will be presenting about Postgres’ present and future. This talk will walk you through what’s new in Postgres 9.5, what’s coming with 9.6, and then round it out with a tour of interesting extensions

Join the conversation on slack

Our code is open and the discussion is too. You’re invited to come join us in our Slack chatroom. We’re talking about feature ideas, and scaling data in general.