On Mon, Sep 12, 2011 at 1:16 AM, Igor Chudov <ichudov@gmail.com> wrote:
> I could, say, set work_mem to 30 GB? (64 bit linux)
I don't think you'd want that. Remember, work_mem is the amount of
memory *per sort*.
Queries can request several times that much memory, once per sort they
need to perform.
You can set it really high, but not 60% of your RAM - that wouldn't be wise.