PostgreSQL is great for data analytics and engineering work.
July 24, 2019
PostgreSQL is great for data analytics and engineering work.
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with PostgreSQL
PostgreSQL on Greenplum is being used as a data warehouse by the entire data and analytics team on my project. There are also other teams using the database as well, but it solves the business problems of running large analytics workflows with billions of rows of archived data to create reporting dashboards. It is able to run in a massively parallel processing format.
- data processing
- big data analytics
- data aggregation
- SQL syntax support
- query error handling
- programmatic access
- provide better data visibility and analytics
- creates new business opportunities in analytics
- needs more technical support and administration
PostgreSQL is the proper tool when data consistency matters and other BASE or document-based databases are simply improper. I think PostgreSQL has a fantastic system of slony replication, triggers, and other data maintenance functionality that other databases generally don't have. The themes of postgres are also varied, but postgres was selected because of it's massively parallel processing functionality and data consistency.