gpdb

gpdb copied to clipboard

[ORCA] Support left/right outer join order hints

6

Commit https://github.com/greenplum-db/gpdb/commit/ef7eec414877eb274e8c4351a2ef425139174d56 added a framework to support inner join order hints. This commit extends that framework to support left (LOJ) and right (ROJ) outer joins. LOJ and ROJ have the...

dgkimura

pg_upgrade: add func to check if guc setting is removed

1

Gucs/settings can be applied to certain databses or roles and are stored in pg_db_role_settings Upgrade would also to restore these settings on target cluster Some of these settings are removed...

divyeshddv

Avoid replay dtx info in checkpoint for newly expanded segments

1

gpexpand will create new segment by doing pg_basebackup from coordinator, and DTX can be started in coordinator during that phase. So the newly added segment's checkpoint XLOG may contain DTX...

zxuejing

Add support for Planhints logging

10

Add support for plan hints logging. This commit supports logging of Used and Un-Used Scan, Row and JoinOrder Hints types. Below is a snippet of how this can be used/looks...

Sanath97

This work is a continuation of plan hints in commit https://github.com/greenplum-db/gpdb/commit/e781fe0db4e3cb24b38be0b8497fc2ebafdd2b7a. This change allows the user to specify join type hints that coerce the optimizer to generate a plan that...

dgkimura

### Overview The PR is to fix issue https://github.com/greenplum-db/gpdb/issues/13402 (similar issue: https://github.com/greenplum-db/gpdb/issues/14475) Basically, for joining a partition table to another normal table, an extra unnecessary Redistribute Motion node is generated...

yaowangm

Implement multi-key sort on GPDB7

9

### Overview Mksort (multi-key sort) is feature of GPDB6. When we merged code of pg12 to GP7, the code path of SORT in pg12 had been rewritten in a large...

yaowangm

Support scalar subquery with multiple columns

1

Description: This PR introduces support for scalar subqueries(BOOLEXPR) with multiple columns in Greenplum, enhancing the query processing capabilities of the system. Which allow for more complex and versatile SQL queries...

pobbatihari

The global deadlock detected process of the greenplum master node has abnormal RSS memory usage.

26

1、02:09:43, See the deadlock information from the log ```bash $ cat gpdb-2024-04-18_000000.csv | grep deadlock 2024-04-18 02:09:43.246943 UTC,,,p26809,th-1525422016,,,,0,con380,cmd5036,seg-1,,,,sx1,"LOG","00000","global deadlock detected! Final graph is :{""seg0"": [""p1241 of dtx3430845286 con1088326 waits for...

yanboer

This commit adds functional tests for expansion support changes pushed in the PR https://github.com/greenplum-db/gpdb/pull/17335 Below changes are included: init_cluster_config_validation_test.go - This contains tests related to the input expansion config validations,...

srividyaky