Greenplum v5 launched in September 2017 and the Greenplum developers have been hard at work since then on the next major version, V6, Code Name Mars, which is slated to release September 2018. In this post I will provide some high level updates on new developments on the V6 code line.
- PostgreSQL 8.4 merge has been completed. Greenplum v5 was based on 8.3, and now 6 has the complete 8.4 base. This is a great milestone but not the last milestone before the GP6 release as we expect to reach 9.x in this cycle. My favorite 8.4 feature is Column Level Permissions.
- WAL Replication replaces File Replication. This has been completed in the 6.0 branch and is a HUGE milestone. File Replication came into Greenplum in 188.8.131.52 in 2010 and introduced what was at the time, state of the art High Availability into Greenplum. FileReplication was a massive feature that had 100,000 person years put into development. WAL Replication has matured and improved in the meantime, and I would expect the uptime (# of 9s) for large mission critical clusters will go UP with GP6 due to the infrastructure in WAL Replication being more robust and more capable. This is also the foundation for future features around disaster recovery and snapshotting. And finally, WAL Replication replacing FileReplication will accellerate our future PostgreSQL code merges and staying in synch with PostgreSQL because the differences between PG and GP will be vastly reduced.
- ZStandard Compression for Append Optimized Tables was contributed by the Arena Data team in Russia. This is a new algorithm that has dramatically less CPU utilization and increased performance for compression. Improved compression is like money in the bank, because you can do more data processing and storage with the same amount of hardware. Really happy to see this improvement
- GIN Indices have been enabled. Previous versions of Greenplum DB did not enable GIN indices due to complications in the mirroring of them. Now that we have standard postgresql mirroring in 6, we can enable this, and it has been merged and enable in 6 this week. Here are some selected blogs highlighting what can be done with GIN: 1, 2, 3.
- Replacement of gpcrondump with gpbackup. gpbackup improves on gpcrondump in many respects, the most popular being reduced lock contention. The lock contention is reduced because the gpbackup design acts as a regular SQL read only user to the database and uses a transaction to get a point in time, so no heavy handed system locking is required during the job.
- Improved concurrency by reducing lock contention is submitted in PR, and seems to have approvals for merge, but is not yet merged. There is quite a bit of concurrency performance work going in development and GP6 should be the highest in terms of concurrency benchmarks we have ever had.
There is still quite a bit of time before we cut 6.0 so its great to see so much completed work already in the next upcoming version! I will provide another update as we see more get merged in.
Working on enterprise software since 2002, and on big data and database management systems since 2007. Started on Greenplum Database in 2009 as a performance engineer and worked in various R&D and support capacities until shifting into product management for the world’s greatest database: Greenplum.