How Greenplum Database tackles petabytes of dataБазы данных и системы хранения
Andreas Scherbaum is working with PostgreSQL since 1997. He is involved in several PostgreSQL related community projects, member of the Board of Directors of the European PostgreSQL User Group and also wrote a PostgreSQL book (in German).
Since 2020 he is working as Head of Databases for Adjust GmbH in Germany.
Greenplum Database is an Open Source fork of the well known PostgreSQL database. It is designed to execute massive workloads using MPP technology, and scale out to dozens or hundreds of servers.
Such a technology is not easy to build, and many challenges need to be mastered along the way. Not only in the database product itself, but also on the operating, filesystem and network level.
This talk shows how Greenplum Database works, it also explains challenges on the way to scale out to many TBs, roadblocks found along the way, and lists some of the common mistakes and problems.
