Craig Kerstiens

We want the process of scaling your data to be easier–whether it's Citus 5.2 making it easier for multitenant applications to scale, ORM support, or real-time analytics and search of your data you shouldn't have to re-engineer everything as your data...

For years we've been focused on making Citus the best solution for scaling out your database. We've seen customers attain up to 100x performance when compared on the same hardware to vanilla Postgres. Of course you don't always need to scale out to get good performance–if you have 10 GB of data a single node Postgres can work great. But at data sizes of 100 GB and up, the need to scale out may exist.

Today, with the release of Citus 5.2, it's now easier to get started earlier so you don't have to worry about when that moment comes where you won't be able to scale up further.

Whether you’re building marketing analytics, a portal for e-commerce sites, or an application to cater to schools, if you’re building an application and your customer is another business then a multi-tenant approach is the norm. The same code runs for all customers, but each customer sees their own private data set, except in some cases of holistic internal reporting.

Early in your application’s life customer data has a simple structure which evolves organically. Typically all information relates to a central customer/user/tenant table. With a smaller amount of data (10’s of GB) it’s easy to scale the application by throwing more hardware at it, but what happens when you’ve had enough success and data that you have no longer fits in memory on a single box, or you need more concurrency? You scale out, often painfully.

If you're looking at Citus its likely you've outgrown a single node database. In most cases your application is no longer performing as you’d like. In cases where your data is still under 100 GB a single Postgres instance will still work well for you, and is a great choice. At levels beyond that Citus can help, but how you model your data has a major impact on how much performance you're able to get out of the system.

Since Postgres started supporting NoSQL (via hstore, json, and jsonb), the question of when to use Postgres in relational mode vs NoSQL mode has come up a lot. Do you entirely abandon traditional table structures, and go with documents all the way? Or do you intermingle both? The answer unsurprisingly is: it depends. Each newer model including hstore, JSON, and JSONB has their ideal use cases. Here we'll dig deeper into each and see when you should consider using them.

At Citus we want to enable you to build real-time applications across large amounts of data with ease. One part of that is Citus makes it simple for you to shard your data and use scale-out capabilities to leverage all your processing power. Another part is Citus Cloud: our managed, hosted offering of Citus running on AWS.

Today taking advantage of Citus becomes even easier with our Citus Cloud database going into general availability. You can read on to discover what’s included with Citus Cloud or sign-up to get started right away.

PG Conf Silicon Valley is happening again this year in November and we're looking to make it even better and more informative than last year. To do that we're looking to you, both as an attendee and to come speak. We've already received a lot of great...

At Citus we believe in making databases easier. Key to that is empowering users to scale Postgres beyond the typical limits of a single node. Our latest Citus release makes it easier than ever to scale memory and processors while retaining access to familiar SQL queries and rich Postgres features. But database management can be tricky even in the single-node case, so we at Citus have been hard at work building the next step in our journey to make databases easier: Citus Cloud, an on-demand cloud service on top of Amazon Web Services available today in private beta. *Citus Cloud is now fully GA, you can learn more here