Pivotal Engineering Journal
Technical articles from Pivotal engineers.
Home
Author
Xin (Shin) Zhang
https://www.linkedin.com/in/xinzweb
@xinzweb
@xinzweb
Posts By Xin (Shin) Zhang
Ashwin Agrawal
Asim Praveen
Daniel Gustafsson
Heikki Linnakangas
Jacob Champion
Melanie Plageman
Xin (Shin) Zhang
Apr 17, 2018
How Pivotal contributes to the Development of PostgreSQL 11
Summary of Pivotal Contributions to PostgreSQL 11
Categories:
Greenplum Database
PostgreSQL
Greenplum
Development
Venkatesh Raghavan
Jesse Zhang
Haisheng Yuan
Omer Arap
Xin (Shin) Zhang
Ivan Novick
Oct 12, 2016
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
Nikos Armenatzoglou
Karthikeyan Jambu Rajaraman
Shreedhar A Hardikar
Craig Chasseur
Foyzur Rahman
George Caragea
Venkatesh Raghavan
Addison Huddy
Xin (Shin) Zhang
Sep 2, 2016
Improving Query Execution Speed via Code Generation
A code generation based solution inside the GPDB execution engine.
Categories:
GREENPLUM DATABASE
QUERY EXECUTION
CODE GENERATION