Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 924F3650689 for ; Sat, 5 Jul 2008 08:24:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 94761-10 for ; Sat, 5 Jul 2008 08:24:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web56414.mail.re3.yahoo.com (web56414.mail.re3.yahoo.com [216.252.111.93]) by postgresql.org (Postfix) with SMTP id 9A2D2650688 for ; Sat, 5 Jul 2008 08:24:51 -0300 (ADT) Received: (qmail 45888 invoked by uid 60001); 5 Jul 2008 11:24:50 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=k+M7UNq5rwv5bGrwZm+neMZZDdvi0JuPEntkthHwzOLixaddv04sa/7S+yFxFVKhkPA/D5Ix5U/++ybBCdccAXbcQW9kCWyMQX70zpxSMdm26VGVHcqLQ9Xgk82faQbPPxiXG+gEtdwDki/z16In204kPr3ZCWOIy4uZC9CNLTg=; Received: from [98.166.112.215] by web56414.mail.re3.yahoo.com via HTTP; Sat, 05 Jul 2008 04:24:49 PDT X-Mailer: YahooMailRC/1042.33 YahooMailWebService/0.7.199 Date: Sat, 5 Jul 2008 04:24:49 -0700 (PDT) From: Jessica Richard Subject: How much work_mem to configure... To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1585574652-1215257089=:45734" Message-ID: <111685.45734.qm@web56414.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200807/51 X-Sequence-Number: 30651 --0-1585574652-1215257089=:45734 Content-Type: text/plain; charset=us-ascii How can I tell if my work_mem configuration is enough to support all Postgres user activities on the server I am managing? Where do I find the indication if the number is lower than needed. Thanks, Jessica --0-1585574652-1215257089=:45734 Content-Type: text/html; charset=us-ascii
How can I tell if my work_mem configuration is enough to support all  Postgres user activities on the server I am managing?

Where do I find the indication if the number is lower than needed.

Thanks,
Jessica

--0-1585574652-1215257089=:45734--