Max Yang
Max Yang
For partition table, is it possible we don't create child partition tables if parent table and child tables have some catalog? So that we don't need to create so many...
``` CREATE TABLE tbl(v int ENCODING(compresstype = ..., compresslevel = ....); ```
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:...
``` 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...