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.
This commit introduces the gp_appendonly_compaction_threshold GUC, which ensures the availability of N segfiles for insert operations, before going forward with a compaction decision. During VACUUM, we decide to drop a...
Sampling on CO tables requires all columns sub-segfiles have the same total `tupcount` presented physically, ADD COLUMN operation didn't populate physical rows which have default values for better performance. This...
AlterTableCreateAoBlkdirTable() is being called unconditionally, it upgrades ShareLock to ShareRowExclusiveLock hence may result in deadlock for concurrent index creation even if block directory is present on the append-optimized table. This...
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...
This is a backport of https://github.com/greenplum-db/gpdb/pull/17345 Currently gpssh always clears out the TERM env variable before performing SSH connections. This will cause problems when users want only to use a...
Currently `gpssh` always clears out the `TERM` env variable before performing SSH connections. This will cause problems when users want only to use a specific terminal (like tmux) when performing...
## Here are some reminders before you submit the pull request - [x] Add tests for the change - [x] Document changes - [x] Communicate in the mailing list if...
Currently, Orca falls back to Planner if a CTE is referenced multiple times and contains outer references. This is due to the way Orca creates CTE producers/consumers for shared scans...
## Bug Report One of our production clusters was repeatedly experiencing coordinator seg faults running this query: ```sql with open_rate_avg as (select sum(tab.opened)*100/sum(tab.sended) as or_avg from (select date(date_trunc('week', date(customer_action_datetime_utc))) as...
## Bug Report query crashes due to assertion failure: ``` explain with abc as (select sum(a)/sum(b) from foo ), c1 as (select sum(a)/sum(b) as col1 from bar) select (select 1...
Metadata
Owner
Metadata
Greenplum Database - Massively Parallel PostgreSQL for Analytics. An open-source massively parallel data platform for analytics, machine learning and AI.