chaotian
chaotian
when we create bitmap-index on column and using bitmap index scan with NULL array condition on this column, then failed. Like this: > create temp table foo (a int); >...
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....
New SYNTAX of resource group cpuset for different master and segment Using syntax like cpuset="1;3-4" could different cpuset of master and segment by semicolon. For example, if we define cpuset="1;3-4",...
In previous [PR](https://github.com/greenplum-db/gpdb/commit/2f590f1), we introduced GUC gp_eager_two_phase_agg to force planner generating multi-stage agg path in Planner, but applying disable costs may not a good choice, we should force planner generate...
After merge [Recognize functional dependency on primary keys](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=e49ae8d3bc588294d07ce1a1272b31718cfca5ef) from upstream, which allows a table's other columns to be referenced without listing them in GROUP BY, so long as the primary...
## Bug Report ### Greenplum version or build 6x ### Installation information ( pg_config ) optimizer = off ### Step to reproduce the behavior create table t1(a int, b int);...
In the 6x side, if the subpath's locus collocates tuples with group keys, the planner favors local sortgroupagg over MDQ join rewrite. We also choose sortgroupagg when the group key...
## Background Currently, the Query Dispatcher (QD) endeavors to terminate all Query Executor (QE) processes within gangs upon receiving cancellation requests such as pg_cancel_backend()/pg_terminate_backend() from the frontend. The process should...
## Bug Report Enhance aggregate replication safety in planner ### Greenplum version or build main ### Reproduce Step ``` CREATE AGGREGATE my_safe_avg (float8) ( sfunc = float8_accum, stype = float8[],...
main https://github.com/greenplum-db/gpdb/pull/17240 ## Here are some reminders before you submit the pull request - [ ] Add tests for the change - [ ] Document changes - [ ] Communicate...