One of the nice things about PostgreSQL regardless of scale are the tools they provide for optimizing your application. EXPLAIN and EXPLAIN ANALYZE are really powerful tools for figuring out why a query performs badly and validating that indexing you add actually improved query performance.
Quick back of the number calculation for a pretty boring B2B CRUD app, at 75TB of data we'd have more income than the GDP of Earth. YMMV.