PostgreSQL - Data Warehousing Technology
August 02, 2019

PostgreSQL - Data Warehousing Technology

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with PostgreSQL

PostgreSQL is being used as the main data warehousing system by our organization for various analytics functions. It is being used across our whole organization both internally and externally to generate reports and other dashboards products. The business problems it addresses is the need to run complex analytics queries without having too much time be burned up by running the query on MySQL.

Pros

  • Data warehousing
  • Analytics
  • Slony replication

Cons

  • Query language consistency
  • In-memory caching is needed
  • Better query optimization
  • Improved analytics and reporting
  • Faster query processing
  • Data consistency and reliability
I give PostgreSQL a 9/10 because this is the best it will get in terms of structured data analytics in SQL. There isn't anything else out there that allows you to run queries consistently and with failover reliability and replication. Most of our analytics are synced over from our transactional database over time.
PostgreSQL works better than MySQL for analytics workflows where a massively parallel processing database architecture is necessary. We used PostgreSQL because it allows better scalability for querying and data analysis compared to the transactional database MySQL that we use.
PostgreSQL is the best solution out there for data warehousing for relational data if that is what you need in your various analytics and dashboarding projects. It doesn't work that well as a transactional database, for that you'd probably want to stick with MySQL. The other flavors of PostgreSQL that are optimized may work better again, depending on your specific data types and workflows.

Comments

More Reviews of PostgreSQL