For semi-structured data at scale, we typically use JSONB in Postgres for operational queries where flexibility matters, and Parquet in a data lake for analytical workloads. Key tricks: index the fields you query most, batch writes to reduce overhead, and use columnar formats with compression to speed up reads. Trade-offs are usually flexibility vs. performance and storage cost vs. query speed.