> I believe you can set work_mem to a different value just for the duration > of > a single query, so you needn't have work_mem set so high if for every > query > on the system. A single query may well use a multiple of work_mem, so you > really probably don't want it that high all the time unless all of your > queries are structured similarly. Just set work_mem='2047MB'; query; > reset > all;
Yes, executing "set work_mem='64MB'" right before the query should be just fine. Setting work_mem to 2GB is an overkill most of the time (99.99999%). Tomas -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
