Citus Cloud

A database for building real-time apps on billions of events

get it

Reviews

Discussion

You need to become a Contributor to join the discussion - Find out how.
Craig KerstiensMaker@craigkerstiens · Product at Citus
Hi, Craig here. I head up Citus Cloud and prior to Citus spent a number of years at Heroku primarily running product for Heroku Postgres. We've had Citus Cloud in a private beta for a number of months and excited to open for general availability. Happy to answer any questions the PH community has.
Randall Degges@rdegges · Developer Evangelist, Stormpath
How is this different than Heroku Postgres? What can I do with it that beats the Heroku PG experience?
Craig KerstiensMaker@craigkerstiens · Product at Citus
@rdegges Citus focuses on much larger scale data. In general if you have 100 GB or less of data Heroku Postgres should work great for you. Single node Postgres still works great as long as your data fits on a single box and the bulk of it in memory. When you start to outgrow a single node (which can be anywhere from 100GB up to 1TB) then getting responsiveness on queries can be hard, especially on aggregations. Due to how Citus shards your data and distributes the workload you get parallelism of multiple instances. This means across well over 10 TB of data you can still have real-time responsiveness: sub-second queries for aggregations, millisecond queries for small lookups, millisecond inserts/updates.
Lukasz Bilangowski@blukasz · Full-Stack Engineer, Consultant, Founder
Hi Craig, you probably get that from time to time - how is Citus different from RedShift? Is Citus more responsive, i.e. real-time database, but RedShift can handle larger data sets?
Craig KerstiensMaker@craigkerstiens · Product at Citus
@blukasz We do get it some :) In general there are a couple of differences. With Redshift you batch load data, and queries are often run in a matter of seconds to minutes. These are often very long SQL queries created by an analyst. You typically only having a small number of concurrent queries run against Redshift. So in general when you have really complex SQL, large amounts of data Redshift can work well at speeding those up. Citus tends to be used more directly within an application. Citus is able to ingest data in real-time (standard inserts). Because of the distributed nature of Citus not the full breadth of SQL maps directly, so some of those things that are common for analysts, such as common table expressions won't work on your sharded tables. It's not a requirement, but most Citus users tend to have a high number of queries run per second against the database as well. Due to the way parallelism works for us there's not a high overhead of over a second for any query, so you can have thousands of users (or well the app for thousands of users) running queries across a large dataset in under a second. Most of these queries tend to be already defined within your application code though.
Lukasz Bilangowski@blukasz · Full-Stack Engineer, Consultant, Founder
@craigkerstiens Yep, different use cases indeed. Thanks for the thorough overview.
Brian LeePro@kay0stheory · code monkey @ theymadethat
I'm already familiar with citus and I think that citus and citus cloud are awesome products, but your landing page could be better. The benefits aren't made clear fast enough vs your nosql competitors and other distributed Postgres products (in the cloud).
Craig KerstiensMaker@craigkerstiens · Product at Citus
@kay0stheory thanks for the feedback. The new homepage is new and very much a work in progress so the feedback is helpful. I would be curious if some of the when to use/when not to use details on the product page help (https://www.citusdata.com/produc...) and you feel that those details are just too buried or is there a different high level message you're hoping to find somewhere in the site but can't find at all?
Brian LeePro@kay0stheory · code monkey @ theymadethat
@craigkerstiens there's nothing wrong with the copywriting on your landing page aside from it missing those two key paragraphs that instantly allows everyone to quickly understand the value of citus and what differentiates it from nosql competitors http://docs.citusdata.com/en/v5....
em talukder@terminally_em · Data Visualization @ COMCAST NBCU
is there any benchmark information comparing Citrus to MemSQL?