* Scott Marlowe (scott.marlowe@xxxxxxxxx) wrote: > I think that you're fixing a symptom, but ignoring the cause. > Twiddling VM parameters may help out, but this problem of too much > memory allocated is the real issue, so yeah, you're just putting off > the inevitable. I don't think changing work_mem down is actually going to reduce the memory allocated without changing the plan to something less optimal. In the end, all of this is putting off the inevitable, if you get enough PGs going and enough requests and whatnot, you're going to start running out of memory again. Same if you get larger data sets that take up more hash table space or similar. Eventually you might need a bigger box, but let's try to get everything in the current box to at least be used first.. Thanks, Stephen
Attachment:
signature.asc
Description: Digital signature
