From: Ulrich <ulrich.mierendorff@gmx.net>
To: Christiaan Willemsen <cwillemsen@technocon.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Configuring for maximum memory usage
Date: Thu, 30 Oct 2008 16:42:55 +0100
Message-ID: <4909D5FF.9070709@gmx.net> (raw)
In-Reply-To: <4909CF9C.80701@technocon.com>
References: <4909CF9C.80701@technocon.com>
Hi,
you could set effective_cache_size to a high value (free memory on your
server that is used for caching).
Christiaan Willemsen wrote:
> Hi there,
>
> I configured OpenSolaris on our OpenSolaris Machine. Specs:
>
> 2x Quad 2.6 Ghz Xeon
> 64 GB of memory
> 16x 15k5 SAS
>
> The filesystem is configured using ZFS, and I think I have found a
> configuration that performs fairly well.
>
> I installed the standard PostgreSQL that came with the OpenSolaris
> disk (8.3), and later added support for PostGIS. All fime.
> I also tried to tune postgresql.conf to maximize performance and also
> memory usage.
>
> Since PostgreSQL is the only thing running on this machine, we want it
> to take full advantage of the hardware. For the ZFS cache, we have 8
> GB reserved. The rest can be used by postgres.
>
> The problem is getting it to use that much. At the moment, it only
> uses almost 9 GB, so by far not enough. The problem is getting it to
> use more... I hope you can help me with working config.
>
> Here are the parameters I set in the config file:
>
> shared_buffers = 8192MB
> work_mem = 128MB
> maintenance_work_mem = 2048MB
> max_fsm_pages = 204800
> max_fsm_relations = 2000
>
> Database is about 250 GB in size, so we really need to have as much
> data as possible in memory.
>
> I hope you can help us tweak a few parameters to make sure all memory
> will be used.
>
>
>
>
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: ulrich.mierendorff@gmx.net, cwillemsen@technocon.com
Subject: Re: Configuring for maximum memory usage
In-Reply-To: <4909D5FF.9070709@gmx.net>
* 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