Re: Out of memory on SELECT in 8.3.5

* Scott Marlowe (scott(dot)marlowe(at)gmail(dot)com) 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