Received: from sss.pgh.pa.us ([216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f35EkJ837103 for ; Thu, 5 Apr 2001 10:46:19 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f35Ek7w16729; Thu, 5 Apr 2001 10:46:08 -0400 (EDT) To: Tim Perdue cc: pgsql-sql@postgresql.org Subject: Re: Memory and performance In-reply-to: <20010405075250.H513@mail.perdue.net> References: <200104041715.f34HF8858323@postgresql.org> <14398.986435610@sss.pgh.pa.us> <20010405075250.H513@mail.perdue.net> Comments: In-reply-to Tim Perdue message dated "Thu, 05 Apr 2001 07:52:50 -0500" Date: Thu, 05 Apr 2001 10:46:07 -0400 Message-ID: <16726.986481967@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200104/80 X-Sequence-Number: 2420 Tim Perdue writes: > Our database is about 1GB in total size, the machine has 4GB, but the entire > system is only using 1.2 GB, even during vacuum or a daily, extremely large > query that requires a lot of grouping and sorting. What have you got the SortMem parameter (backend -S switch) set to? That's about the only use I can think of for RAM beyond what's needed to cache the whole database ... regards, tom lane