From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tim Perdue <tim@perdue.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Memory and performance
Date: Thu, 05 Apr 2001 10:46:07 -0400
Message-ID: <16726.986481967@sss.pgh.pa.us> (raw)
In-Reply-To: <20010405075250.H513@mail.perdue.net>
References: <200104041715.f34HF8858323@postgresql.org>
<14398.986435610@sss.pgh.pa.us>
<20010405075250.H513@mail.perdue.net>
Tim Perdue <tim@perdue.net> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, tim@perdue.net
Subject: Re: Memory and performance
In-Reply-To: <16726.986481967@sss.pgh.pa.us>
References: <200104041715.f34HF8858323@postgresql.org> <14398.986435610@sss.pgh.pa.us> <20010405075250.H513@mail.perdue.net> <16726.986481967@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox