Author | Soumyadeep Chakraborty Subtransaction overflow can really bring a cluster to it’s knees, if coupled with long running transactions. It manifests when any given backend creates more than 64 subtransactions in any given transaction that it runs. This can happen on the master as well as primaries.

Greenplum 6 contains multiple optimizations for OLTP scenarios, greatly improving the performance of simple query, insert, delete, and update operations in high concurrent situations. These improvements include: Updating the PostgreSQL kernel version to 9.4. This update brings a new set of features while also improving the overall performance

Greenplum Database version 6 has released its beta release in March 2019 and the community of users is eagerly awaiting the huge release as a GA 6.0.0 which is pending according to community communications in about end of June time frame (plus/minus). Greenplum Database 6 is packed with

Gpexpand is a cluster expansion tool for Greenplum. It can provide more storage space and computing capacity by adding new hardware to an existing cluster. First its important to understand that a Greenplum cluster consists of many database segments. You can think of segments as the individual postgres