On Mon, Sep 12, 2011 at 1:16 AM, Igor Chudov <ichudov@xxxxxxxxx> 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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
