A data warehouse is a special type of database designed for analytics instead of transactions.
There are two main types of databases: transactional and analytical. Transactional databases like PostgreSQL are built for adding, updating, and removing data, but analytical DBs are for complex queries and joins. When you're analyzing big swaths of data to understand patterns in product usage or look at revenue over time, you want to use a data warehouse.