Level: Intermediate
The Role of Database Sharding in Advancing Research: As users of the open-source Greenplum database, we faced a significant challenge when Broadcom decided to close the software in May 2024. This decision necessitated finding alternative solutions to replace our Greenplum clusters, which store terabytes of Universe object information essential for ongoing scientific research and discoveries. Our evaluation process focused on two potential replacements: Citus and EDB WarehousePG. This talk presents the comprehensive evaluation and benchmarking results of these alternatives.