Not all relational DBs break at scale.
Relational DBs break at scale if you rely on very specific optimizations like specific types of indexes.
Even Postgres got this right recently with the introduction of the BRIN index, which is a lot more lightweight.
Look at Netezza, Oracle Exadata, and (disclaimer: I work on this) SQream DB, which can absolutely handle hundreds of terabytes without too much fuss.