Hello Tao,
I'm not sure it was a bug and I also cloud not explain why it
allocated so much memory.Dosn't each sub partition table allocated the
size of work_mem memory and not free it?
It can, and it did it for hashed subPlan at least in PG 9.4, see
https://www.slideshare.net/AlexeyBashtanov/
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 th
