Category

Kristine Scott

Avoiding subtransaction overflow in GPDB6

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.

Read More »

Generated Columns in Greenplum 7

Authors: Ashwin Agrawal, Divya Bhargov, Kristine Scott Greenplum 7 brings in the STORED generated columns feature from Postgres 12. In this blog post, we’ll take a closer look at stored generated columns and explore their benefits and use cases. Generated columns are useful for cases where the calculated

Read More »