Greenplum closed its source. What are our options?
Since May 2024 Greenplum is a commercial product, VMware Tanzu Greenplum, and the open-source repositories were archived. You can license Tanzu Greenplum, move to a fork such as Apache Cloudberry or WarehousePG, or keep the cluster you have with independent support. AceMQ supports the cluster you have, licenses Tanzu Greenplum in the United States, and helps compare the three routes.
Who answers when a Greenplum segment fails or queries stall, and how fast?
A named AceMQ senior DBA answers within 15 minutes, 24/7, when a segment fails, the cluster runs degraded or queries stall, on VMware Greenplum and open-source builds. Lower severities get a first response within 1 hour, 4 hours or the next business day, and the DBA stays until the root cause is documented.
Which Greenplum versions and platforms does AceMQ support?
AceMQ supports Greenplum 5.x, 6.x and 7.x on bare metal and virtual machines, vSphere, and AWS, Azure and Google Cloud, for VMware Greenplum and open-source builds. Coverage includes PXF, gpbackup and gprestore, gpload, JDBC and ODBC connectivity for BI tools, and the gpsupport utility for collecting logs when a case needs one.
How do we fix Greenplum data skew without rebuilding the cluster?
Find the skew first: the gp_toolkit skew views and per-segment row counts show which tables are uneven and why. Then redistribute those tables on a better key, or distribute randomly where no good key exists, one table at a time with query plans compared before and after. No cluster rebuild is needed.
Why do Greenplum queries queue and never start during the ETL window?
Usually resource queue or resource group limits let a few heavy statements hold the active-statement and memory slots, so everything behind them waits. AceMQ reviews the queues or groups, statement_mem and concurrency against your real workload mix, and separates ETL from reporting so one ad hoc query cannot take the cluster.
Can AceMQ license VMware Tanzu Greenplum for us?
Yes, in the United States only. VMware Tanzu licensing carries a 72-core minimum. AceMQ, Broadcom's Expert Advantage Partner of the Year for the Americas, sizes your cluster against it, reconciles deployed capacity with your entitlements, and handles the subscription from purchase to renewal. Licensing quote requests are answered within 1 hour.
Can you migrate us from Teradata, Oracle or Netezza to Greenplum?
Yes. AceMQ has run migrations from Teradata, Oracle, Netezza and Vertica to Greenplum, covering SQL dialect translation, data type mapping, distribution key design, ETL redesign with gpload and external tables, and row-level validation before cutover. We also upgrade 5.x and 6.x clusters to 7 with documented rolling procedures and a tested rollback.
How does a Greenplum engagement start, and how do you work with our team?
It starts with a scoping call scheduled within 24 hours, then a 1 to 2 week review of segment layout, skew, resource queues, vacuum and mirror state. Findings are written up within a week and changes are made alongside your DBAs, table by table. You keep the runbooks, and ongoing support is optional.
Can we work with AceMQ on Greenplum without a long contract?
Yes. AceMQ works on Greenplum in two ways: ad hoc engagements for a defined piece of work, such as a health check, an upgrade or an incident, or an annual partner engagement that covers 24/7 support, proactive reviews and named engineers. Many teams start ad hoc and move to an annual partnership once the first engagement is done.
How much does AceMQ Greenplum support or consulting cost?
Every AceMQ proposal is tailored to your requirements: your Greenplum environment, the SLA you need, the hours of cover and the scope of work. We do not send generic quotes or publish a price list, because two estates of the same size rarely need the same thing. Request a quote and AceMQ replies within 1 hour.
PostgreSQL
Linux
VMware vSphere
AWS
