Thomas Munro <thomas.mu...@gmail.com> writes: > On Fri, May 17, 2019 at 4:39 AM Tomas Vondra > <tomas.von...@2ndquadrant.com> wrote: >> I kinda like the idea with increasing the spaceAllowed value. Essentially, >> if we decide adding batches would be pointless, increasing the memory >> budget is the only thing we can do anyway.
> But that's not OK, we need to fix THAT. I don't think it's necessarily a good idea to suppose that we MUST fit in work_mem come what may. It's likely impossible to guarantee that in all cases. Even if we can, a query that runs for eons will help nobody. regards, tom lane