Citus Con: An Event for Postgres is a wrap! 💥 Thanks to all who joined. If you missed the event, you can still find and watch all 38 recorded talks 🖥 online.
Scale out Postgres by distributing your data & queries across a cluster. And it’s simple to add nodes & rebalance shards when you need to grow.
Parallelized Performance
Speed up queries by 20x to 300x (or more) through parallelism, keeping more data in memory, higher I/O bandwidth, and columnar compression.
Power of Postgres
Citus is an extension (not a fork) to the latest Postgres versions, so you can use your familiar SQL toolset & leverage your Postgres expertise.
Simplified Architecture
Reduce your infrastructure headaches by using a single database for both your transactional and analytical workloads.
Open Source
Download and use Citus open source for free. You can manage Citus yourself, embrace open source, and help us improve Citus via GitHub.
Managed Database Service
Focus on your application and forget about your database. Run Citus in the cloud as a built-in option on Azure Database for PostgreSQL.
Citus = Postgres At Any Scale
Citus is an open source extension that transforms Postgres into a distributed database. Because Citus is a Postgres extension, you can leverage the Postgres features, tooling, and ecosystem you love. Citus 10 adds new features like columnar storage and single-node Citus—plus we’re open sourcing the shard rebalancer. With Citus 10, you can scale from single-node Citus to a large distributed cluster. Which is why we now say: “Citus gives you Postgres at any scale.”
SaaS apps often have a natural dimension on which to distribute data across nodes—dimensions such as tenant, customer, or account_id. Which means SaaS apps have a data model that is a good fit for a distributed database like Citus: just shard by tenant_id.
Customer-facing real-time analytics dashboards need to deliver sub-second query responses to 1000s of concurrent users, while simultaneously ingesting fresh data and enabling users to query the fresh data in real time, too.
By scaling out Postgres across multiple nodes, Citus gives your analytics dashboards the compute, memory, and performance they need to process billions of events in real time.
Whether your app works with financial data, website analytics, IOT data, ad tech, or any other type of monitoring data—time series workloads often need to grow beyond the memory, compute, and disk of a single node.
Citus gives you parallelism, a distributed architecture, and columnar compression to deal with large data volumes—and can be combined with PostgreSQL’s time partitioning to optimize your timeseries queries.
Features for Time series workloads
Sub-second query responses for billions of events
Citus columnar for compression of older data
Integrated with native Postgres partitioning (& pg_partman)
See how Citus gives this application ~20X faster transactions and 300X – 150,000X faster analytics queries.
A side-by-side comparison of Citus vs. single-node Postgres, comparing the performance of transactions, analytical queries, and analytical queries with rollups.
Customers ask how many weeks they have to wait for results, but with Citus it takes us roughly three minutes. The difference is so striking compared to our competitors, customers usually struggle to understand how we can do it.
We expected a database migration to be a huge code change, requiring a lot of rewrites. But Citus has a Django multi-tenant library, which minimized the refactoring to migrate our application. Except for rewriting a few lines of our app, we ended up using pretty much the same code.
Citus handles our complex ingest and delete operations seamlessly—and that’s with a workflow that creates five to ten billion new rows of data per day. The way in which Citus shards and distributes data across multiple nodes has given us the parallelization we need.
Thanks to Citus, we’re powering a product that is really kind of magical for a lot of customers. The speed and performance of our database make it possible for them to immediately perform truly advanced analytics on any user activities they want to explore.
We provisioned a new database using the Citus console, ran our migrations, copied over our data from Heroku, and we were up and running on Citus in just a few minutes. And the technical benefits were instant. We saw queries that were once taking 15-30+ seconds reduced to less than 500 ms.
