Yeah, kinda(not shared buffers but something else). Each table/index has overhead.
Question: Do you know of ANY db that you can do 1 db/customer ?(for 1 million customers) Just like I thought, no.
Question: Do you know of ANY db that you can do 1 db/customer ?(for 1 million customers) Just like I thought, no.
EDIT: Well, looks like someone beat me to it
There's no reason you can't either run more servers or multiple instances of postgres per server, with docker or otherwise.
I'm probably going to try using Citus Data instead of moving to Cassandra if I ever get big. We'll see.
In a usecase where you consider independent databases, with few interactions between them, for millions of users (and a few MBs + binary blobs of data per user) I'd certainly consider it as a possible solution.