Yes, I reversed my Methods in my summation. If I understand you correctly you are suggesting that I try:
create temporary table if not exists temp_rslt of ypxportal2__fgetquestions on commit drop;
truncate temp_rslt ;
I tried it and it works !!!
no more ERROR: out of shared memory !!!
Thanks so much!
Mike