A type of database that can be used for several purposes. Postgres is perfect for a data warehouse when setting up analytics tooling such as Segment. Due to the schema being explicit and data tables being organized in a hierarchy it makes reporting and sifting through tables in reporting tools like Metabase infidelity easier.
One drawback is that at scale (meaning millions of users) a Postgres database can become slow due to the high volume of requests. At that point there are additional technical solutions that can be added such as using Kafka, Spark, and/or Hadoop.