Databases · Pivotal Engineering Journal
GiST Support In GPORCA
We look at how GIST indexes can be supported in GPORCA, allowing GPORCA to generate plans providing better query execution times.
Create Regression Tests for Greenplum Database
How to create new regression tests for Greenplum Database
The gpfdist protocol for External Tables in Greenplum Database
The internals of the gpfdist protocol used for External Tables in Greenplum Database
Trilogy and Greenplum for Data Science TDD
How to use a new SQL testing framework called
Trilogy with Greenplum Database to help you
test drive your data science code.
Trilogy - the database testing framework
A quick overview of a new database-agnostic SQL testing framework
The File protocol for External Tables in Greenplum Database
The internals of the File protocol used for External Tables in Greenplum Database
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.
GPDB merge with PostgreSQL 8.3
Greenplum merge with PostgreSQL 8.3
Improving Constraints In ORCA
ORCA is Pivotal’s Query Optimizer for big data. We look at how we improved ORCA’s understanding of logical constraints.
Using Postgres to analyze ride data
Postgres provides some fantastic functionality to help out with basic data analysis. This article will show you how to generate leaderboards and find streaks in raw sql data.
SERIAL Datatype Performance in Greenplum Database
How to improve the performance of the SERIAL datatype in Greenplum Database
Current TransactionID in Greenplum Database
How to find out the current TransactionID in Greenplum Database
Pivotal Data Open Source in 2016: community, community, community!
When it comes to Open Source, Pivotal had one kick ass of a year in 2015. Here’s a sneak peak for 2016.
GPORCA, A Modular Query Optimizer, Is Now Open-Source
GPORCA has achieved an overall 5X performance improvement across all 99 industry standard benchmark queries. Now we call on the community to help take the project to the next level.