@rdegges Citus focuses on much larger scale data. In general if you have 100 GB or less of data Heroku Postgres should work great for you. Single node Postgres still works great as long as your data fits on a single box and the bulk of it in memory.
When you start to outgrow a single node (which can be anywhere from 100GB up to 1TB) then getting responsive…See more