rat=> select distinct categories into table uuu from abstract; (hang).... well, CPU usage is increasing dramatically, with no apparent result.
Apply this patch:
*** src/backend/executor/nodeUnique:1.5 1995/02/12 02:55:49
--- src/backend/executor/nodeUnique.c 1995/05/24 21:48:52
***************
*** 205,211 ****
InvalidBuffer,
true);
! return slot;
}
/* ----------------------------------------------------------------
--- 205,211 ----
InvalidBuffer,
true);
! return resultTupleSlot;
}
/* ----------------------------------------------------------------