From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andy <frum@ar-sd.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Server misconfiguration???
Date: Mon, 10 Oct 2005 10:18:45 -0400
Message-ID: <20487.1128953925@sss.pgh.pa.us> (raw)
In-Reply-To: <006f01c5cd76$2b166490$0b00a8c0@forge>
References: <006f01c5cd76$2b166490$0b00a8c0@forge>
"Andy" <frum@ar-sd.net> writes:
> I get the feeling the server is somehow missconfigured or it does not
> work at full parameter. If I look at memory allocation, it never goes
> over 250MB whatever I do with the database.
That is not wrong. Postgres expects the kernel to be doing disk
caching, so the amount of memory that's effectively being used for
database work includes not only what is shown as belonging to the
PG processes, but some portion of the kernel disk buffers as well.
You don't really *want* the processes eating all of available RAM.
I concur with Chris K-L's comments that you should reduce rather
than increase your settings.
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, frum@ar-sd.net
Subject: Re: Server misconfiguration???
In-Reply-To: <20487.1128953925@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