gpdb

gpdb copied to clipboard

FIXME (WIP): Allow SPE plans to show "Partitions selected: 1 (out of 5)"

2

""GPDB_12_MERGE_FIXME: we used to show something along the lines of "Partitions selected: 1 (out of 5)" under the partition selector. By eleminating the (static) partition selector during translation, we only...

pobbatihari

Previously, if a distributed transaction has 1 segment wrote WAL and 2 segments just executed read only queries, 2PC will be used for this distributed transaction. But actually, 1PC is...

zhrt123

Replace netstat with ss (code cleanup)

1

netstat has been replaced with ss earlier but some of the variable names and commented out codes were left as it is. This commit cleans up the old mentions of...

jnihal

5X: could not fsync segment N of relation N/N/N: No such file or directory

1

### Greenplum version or build [5.26](https://github.com/greenplum-db/gpdb/releases/tag/5.26.0) ### OS version and uname -a Red Hat Enterprise Linux Server release 7.6 (Maipo) `Linux ... 3.10.0-957.el7.x86_64 #1 SMP Thu Oct 4 20:48:51 UTC...

leskin-in

Support intermediate aggregate in planner

3

Support intermediate aggregate in planner on GPDB7. AS we know, count(distinct xxx) cannot use hashagg. Usually we handle count(distinct) by single groupagg in MPP which maybe slow when sort involved....

charliettxx

## Enhancement commit 8383593168abb9084ee9c1da07ab5fb6a40ce639 forbid to compare time related type with another if they are not exactly the same. But in tpcds case，it awalys lead to an inaccurate estimation. for...

wangpanCN

Segment Unexpected internal error: Segment process received signal SIGSEGV

5

## Bug Report ### Greenplum version or build Greenplum Database 6.19.4 build commit:953778b47d418bb463e4abb2d982ba27dd281010 Open Source ### OS version and uname -a Linux mdw 3.10.0-1160.59.1.el7.x86_64 #1 SMP Wed Feb 23 16:47:03...

dblife1024

DISTINCT gives incorrect result in array_agg

2

## Bug Report ### Greenplum version or build PostgreSQL 12beta2 (Greenplum Database 7.0.0-alpha.0+dev.15588.gfad65d7 build commit:fad65d796f7d2b7c17884d67ed7b79b216f11a71) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180303 (Red Hat 7.3.1-5), 64-bit compiled on Jul...

orhankislal

A FIXME was left noting whether to use AccessShareLock or NoLock when opening child tables to merge their stats. Since we are not updating or even opening the child tables,...

huansong

## Bug Report In GPDB, expression subquery is promoted to join, e.g. select * from T where a > (select 10*avg(x) from R where T.b=R.y); in postgres, the plan is:...

lmzzzzz1