cloudberry

cloudberry copied to clipboard

No plan has been computed for required properties

2

### Cloudberry Database version warehouse=# select version(); version ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------ PostgreSQL 14.4 (Cloudberry Database 1.4.0 build commit:e83e3ffc22d538deb2dbceeeae0138ca2de064e6) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 10.2.1 20210130 (Red Hat 10.2.1-11), 64-b it...

liyxbeijing

### Cloudberry Database version cbdb version: ``` version --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------- PostgreSQL 14.4 (Cloudberry Database 1.4.0 build commit:e83e3ffc22d538deb2dbceeeae0138ca2de064e6) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 10.2.1 20210130 (Red Hat 1 0.2.1-11), 64-bit...

liyxbeijing

### Cloudberry Database version ``` version --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------- PostgreSQL 14.4 (Cloudberry Database 1.4.0 build commit:e83e3ffc22d538deb2dbceeeae0138ca2de064e6) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 10.2.1 20210130 (Red Hat 1 0.2.1-11), 64-bit compiled on...

liyxbeijing

my-ship-it

my-ship-it

``` CREATE TABLE tbl(v int ENCODING(compresstype = ..., compresslevel = ....); ```

my-ship-it

SQL editor support

2

my-ship-it

We need to understand why Cloudberry occupies more memory than PG, and think is it possible to reduce memory? PG memory usage ``` VmHWM: 13480 kB VmRSS: 13480 kB RssAnon:...

my-ship-it

``` gpadmin=# explain SELECT * FROM distinct_1, distinct_2 WHERE distinct_1.a IS not DISTINCT FROM distinct_2.a; QUERY PLAN ------------------------------------------------------------------------------------------------------ Gather Motion 1:1 (slice1; segments: 1) (cost=10000000000.00..10139293190.55 rows=9273690 width=8) -> Nested Loop...

my-ship-it

Refactor ORCA code to support Access Method

7

my-ship-it