Postgres doesn't need to scan them all because it has indexes. It also has a number of random sampling strategies available. It is niche, but it's a viable opt

Postgres doesn't need to scan them all because it has indexes. It also has a number of random sampling strategies available. It is niche, but it's a viable option for a lot of use cases if you need to limit the number of service dependencies.