gpdb
gpdb copied to clipboard
greenplum-db
Greenplum Database - Massively Parallel PostgreSQL for Analytics. An open-source massively parallel data platform for analytics, machine learning and AI.
## reproduce ```sql gpadmin=# select version(); version -------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------- ------------------------ PostgreSQL 12.12 (Greenplum Database 7.1.0+dev.109.g2a14c41782d build dev) on x86_64-pc-linux-gnu, comp iled by gcc (Ubuntu 11.3.0-1ubuntu1~22.04.1) 11.3.0, 64-bit compiled on Feb...
Views that use deprecated operators will cause upgrade to fail. This happens during metadata restore on the target cluster because pg_restore will error trying to create a view using types...
Views that use deprecated operators will cause upgrade to fail. This happens during metadata restore on the target cluster because pg_restore will error trying to create a view using types...
Currently, ORCA projects all columns for DML operations, which means that deleting a row requires populating all of the columns in the targetlist. For deletes, the only necessary columns are...
On one of our production clusters phase 'gpexpand execute segment cleanup commands' took 46 minutes and did not free up the disk space needed for further manipulations. We do not...
PR description ---------- 1. This PR firstly made two pre-requisite changes: ``` Request syncrep for the forget commit in the remote_apply mode Write nextGxid as-is in checkpoint ``` Please review...
This PR adds support for Query Parameters and parameterized queries to Orca. Previously, Orca would fall back. These come in 2 forms: 1. As functions, eg: ``` CREATE FUNCTION somefunc(INT,...
Previously, Orca would generate unused extra slices when the plan contained Subplans. This was due to a bug in the logic that set the number of InitPlans (which do require...
In preprocessing, ORCA may choose to add select filters in order to help trigger predicate push down during query normalization. In preprocessing step PexprReplaceColWithConst(), a duplicate filter is created with...
In Query to DXL translation, one of the tasks in RetrieveRel() is to get the relation keyset. That keyset defines the table descriptor used in the query. In the case...
Metadata
Owner
Metadata
Greenplum Database - Massively Parallel PostgreSQL for Analytics. An open-source massively parallel data platform for analytics, machine learning and AI.