Pivotal Engineering Journal

Technical articles from Pivotal engineers.

Xin (Shin) Zhang

Posts By Xin (Shin) Zhang
  1. Development of Greenplum for Kubernetes using Minikube Speed up agile developing process using a minikube Categories:   Greenplum    Kubernetes    Agile   
  2. How Pivotal contributes to the Development of PostgreSQL 11 Summary of Pivotal Contributions to PostgreSQL 11 Categories:   Greenplum Database    PostgreSQL    Greenplum    Development   
  3. Profiling Query Compilation Time with GPORCA GPORCA is Pivotal’s Query Optimizer for Greenplum Database and Apache HAWQ (incubating). In this post, we describe how users can profile query compilation with GPORCA. This will aid users in understanding which of GPORCA’s steps is the most resource intensive, and what transformations are being triggered. Based on this information, users can provide query hints to reduce or increase the search space, see where the time and memory is being spent, and learn how to influence its decision making. Categories:   Databases    GPDB    HAWQ    PQO    GPORCA    Query Optimization    SQL   
  4. Improving Query Execution Speed via Code Generation A code generation based solution inside the GPDB execution engine. Categories:   GREENPLUM DATABASE    QUERY EXECUTION    CODE GENERATION