IME a warehouse is usually accommodating of structured and unstructured data, has decoupled storage and compute, and is optimized for analytics/big data (as opp

IME a warehouse is usually accommodating of structured and unstructured data, has decoupled storage and compute, and is optimized for analytics/big data (as opposed to app-tier databases which are normally optimized for throughput). I think the buzzword is really centered around intent, not actual technical ability. You _could_ use Postgres as a data warehouse, given it supports JSON types, but you wouldn't be taking advantage of all the innovation that's gone into the warehousing space.