POSETTE 2024 is a wrap! 💯 Thanks for joining the fun! Missed it? Watch all 42 talks online 🍿
POSETTE 2024 is a wrap! 💯 Thanks for joining the fun! Missed it? Watch all 42 talks online 🍿
Written by Marco Slot
March 9, 2015
One of the nice things about working at Citus Data is that we get time and budget to work on personal growth projects. A few of us are playing with the Raspberry Pi. I recently got two Raspberry Pi 2's and installed the Raspbian distribution on 16GB SD cards.
Of course, the first thing I tried was to install CitusDB (our solution for massively scaling PostgreSQL across a cluster of commodity servers) andpg_shard and make them crunch some numbers. For this set-up, one of the Pi's acted as both master and worker node and the other one as a regular worker node. The Raspberry Pi 2 is a modest device, so I used a modest 1GB dataset from the TPC-H and ran the first query, which gave the following result:
CitusDB | PostgreSQL | |
---|---|---|
Q1 | 11.9s | 85.0s |
What's astonishing about the Raspberry Pi 2 is how cost-effective it is for running CitusDB. The total investment in this set-up, including the microSD cards, was about $100. A cluster of 4-5 Pi's should be on par with a high performance desktop twice the cost.
Now, you might be wondering whether I brought down the whole cluster by taking a picture due to theRaspberry Pi 2's camera shyness. Yes, yes I did. Next time I'll place the Pi's in separate locations such that CitusDB will mask the node failure when taking pictures :).
We don't currently distribute a package for Raspbian, but contact us if you would like to try yourself.