On Tue, Sep 22, 2009 at 1:36 PM, Alan McKay <alan.mckay@xxxxxxxxx> wrote: > Too high? How high is too high? in a very simple scenario, you have 100 connections opened, and all of them run the query that was the reason you bumped work_mem to 256M. All of the sudden postgresql starts to complain about lack of ram, because you told it it could use max of work_mem*number_of_connections. Best practice to avoid that, is to bump the work_mem temporarily before the query, and than lower it again, lowers the chance of memory exhaustion. -- GJ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
