Re: [HACKERS] execGrouping.c limit on work_mem

2017-05-28 Thread Tom Lane
Jeff Janes writes: > In BuildTupleHashTable > /* Limit initial table size request to not more than work_mem */ > nbuckets = Min(nbuckets, (long) ((work_mem * 1024L) / entrysize)); > Is this a good idea? If the caller of this code has no respect for > work_mem, they are still going to blo

[HACKERS] execGrouping.c limit on work_mem

2017-05-27 Thread Jeff Janes
In BuildTupleHashTable /* Limit initial table size request to not more than work_mem */ nbuckets = Min(nbuckets, (long) ((work_mem * 1024L) / entrysize)); Is this a good idea? If the caller of this code has no respect for work_mem, they are still going to blow it out of the water. Now