> I've tested only on a table with a few million rows I've tested postgres with > 250m rows. It has problems. I've also tested to 1b rows, same issue. Now t

> I've tested only on a table with a few million rows I've tested postgres with > 250m rows. It has problems. I've also tested to 1b rows, same issue. Now throw in some sum, count and group by functions, more issues. Add a join? Now you've major problems. Add several joins? Woah there! I've been able to bring a 5 node citusDB cluster to it's knees. Which the only solution was to scale out massively to double digits servers. But you can't do that on a limited budget. The caveat here, this was about 2 years ago now. I don't know if there have been any improvements since that time. I don't have a postgres database now, I've since migrated over to memsql as the majority of my work is OLAP.