Is PostgreSQL On My Raspberry Pi Faster Than Your Cloud PostgreSQL Instance
October 20–23
Where and how to host your PostgreSQL comes with a range of tradeoffs, usually cost and performance related. With cloud vendors with turn-key style services seemingly becoming default choices, but at what cost.
This talk will take a look at the different tradeoffs of where and how to host your PostgreSQL database. We'll cover ways in which you can benchmark your infrastructure and how different solutions can affect performance vs cost.
Looking at things like: - Ways to benchmark and understand storage and PostgreSQL performance - Local vs network attached storage and how this affects performance - Can we make network attached storage almost as fast as local storage - How availability comes into play - How replication and data safety requirements can affect things - How does performance for price compare - Tradeoffs of self hosting
And trying to answer the fun question, is PostgreSQL on my Raspberry Pi faster than some common cloud offerings? If so, at what cost?