partition table query allocate much memory

hi guys, I'm not sure it was a bug,but a query on partition table allocate nearly 100GB memory is not normal.pid :119775 as below [cid:part1.2A42CFAD.715BF014@outlook.com] SQL: SELECT DISTINCT etl_source,gid FROM zh_erp.buy2 WHERE gid NOT IN (SELECT gid FROM zh_erp.goodsh); I had modified

copy error with json/jsonb types

hi dears, I'm using copy and jdbc copyin to build load data to pg,data type in table is jsonb.postgresql version are 9.6 and 10.0. Some records with escape characters would be failed with error"ERROR: invalid input syntax for type json" but when using insert they could be executed