Citus Unforks From PostgreSQL, Goes Open Source
Citus Unforks From PostgreSQL, Goes Open Source
When we started working on CitusDB 1.0 four years ago, we envisioned scaling out relational databases. We loved Postgres (and the elephant) and picked it as our underlying database of choice. Our goal... Read more
PostgreSQL, pg_shard, and what we learned from our failures
PostgreSQL, pg_shard, and what we learned from our failures
pg_shard is a PostgreSQL extension that scales out real-time read and writes. This document talks about an earlier version of pg_shard that used Postgres' foreign data wrappers (FDWs) for... Read more
First PGConf Silicon Valley Speakers Announced
As a member of the PGConf Silicon Valley Conference Committee, I'm extremely happy with the volume and quality of the talks submitted to the conference. The Committee has been working hard on sorting through the talks, and I am pleased to announce... Read more
CitusDB 4.0, pg_shard 1.1, and cstore 1.2 are out. What's next?
We're excited to release CitusDB 4.0, pg_shard 1.1, and cstore 1.2! These products extend PostgreSQL for scaling out and high performance.
Now that our new releases are out, we wanted to answer two questions that we continuously hear from our users... Read more
Scaling out PostgreSQL at CloudFlare with CitusDB
CloudFlare is a content delivery network (CDN) and DNS provider that powers millions of websites around the world. Last week, we were happy to see them publish a technical blog post that described how they power their analytics dashboards using... Read more
pgDaySF 2015 Takeaways
We recently attended pgDaySF, the one-day PostgreSQL event organized by the San Francisco PostgreSQL User Group and part of the bigger FOSS4G conference. The event was very well attended, and we were excited by the content of several presentations... Read more
How to Build Your Distributed Database (1/2)
How to Build Your Distributed Database (1/2)
The first distributed database that I worked on was called CSPIT. The project was led by a visionary architect and involved some of the smartest developers I knew at Amazon.
CSPIT never saw the light of... Read more
SQL, Scaling, and What's Unique About Postgres
SQL, Scaling, and What's Unique About Postgres
This blog post simplifies certain concepts to be brief. If you're looking for examples on how to override the PostgreSQL planner and executor, please check out pg_shard.c here.
By now, you've likely... Read more
Real-time SQL on Hadoop
We are excited to bring together the performance of PostgreSQL and the scalability of Apache Hadoop, and enable real-time queries on data that's already in Hadoop. This new functionality becomes possible with CitusDB's powerful distributed query... Read more
Postgres Performance: To avg or To sum/count
One of our attentive readers called out on a performance "discrepancy" we had in our earlier benchmark results. We noted that the CitusDB worker node had its data partitioned into 4 shards to make use of all 4 CPU cores. Apart from that, the worker... Read more
PostgreSQL Foreign File Performance
One of the neat features introduced in PostgreSQL 9.1 is foreign tables. This feature allows users to declare a foreign table for an external data source, and run queries on that table using SQL. The key component that enables this is a foreign data... Read more
Run SQL on MongoDB. Wait, say what?
MongoDB and PostgreSQL are two of the most popular databases in the open source world. One neat idea that relates to these databases and that recently became possible is: keeping all your data in MongoDB, while still running the full spectrum of SQL... Read more
Subscribe to Blog