You can scale nearly anything if you know what you're doing.

There seems to be many many options at attempting/trying to scale postgresql, what are your opinions of them?

Also It is my sort of opinion that you really have a good problem if postgresql isn't working you because of the problem of scale and that, evaluation of other problems become much easier but in general, its easier to start with postgresql.

(Personally, I use sqlite + golang static binaries on a 500mb/1gb ram server, so I can't comment too much on the scale part as I am focused much more on simplicity yet I admire how aside from sqlite (which is also more scalable than people think!) postgresql is almost always good enough in my opinion though I can be wrong and I usually am)

Like, what kind of measurement is "largest"? Most bytes on disk?