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.

At Algolia, our job is to provide the best search as a service, not to maintain clusters of PostgreSQL servers. We really wanted a database that scales, a database we wouldn’t have to worry about. Citus has given us that.

I like Citus’ combination of features, open source flexibility, and commercial-grade scalability. Best of all, because Citus is built on the latest version of PostgreSQL, we have been able to continue using the same core SQL toolset, leverage our existing PostgreSQL expertise, and take advantage of the continuing innovation within the PostgreSQL community.

Usually for analytics applications, acceptable response times can be a matter of seconds. And this is especially true for long-term reporting that needs to query a huge amount of data. With Citus, it’s amazing. The response time on long-term queries of billions of rows is on the order of milliseconds.

With Citus, we don’t have to worry about our infrastructure. That’s one of the main reasons I’m on Citus. We don’t have to think about DevOps anymore. We’re automatically and seamlessly scaling in the cloud, and we’re now managing more than 6,500 ecommerce stores.

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.