Citus Newsletter

Archive for June 2016

Made with    from the Postgres team at Microsoft

 
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 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!

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



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.

Subscribe to the Citus Newsletter

A monthly email with the latest posts about Postgres & the Citus database extension

Made with    from the Postgres team at Microsoft