Pinned
Using Postgres as a Data Warehouse
- Start with Postgres 18+ — asynchronous I/O makes table scans 2-3x faster than Postgres 15
- One command runs everything: `docker-compose up`. If partitioning breaks on localhost, it'll break in prod — test the real structure first
- Async

